Session

Working with Power BI API's via Power Automate: exporting data and controlling Embedded capacity

First application: exporting Data
If you want to export data from Power BI via Power Automate, then there are a few options: Export Paginated reports, use the Power Automate button in Power BI and recently also a WebAPI call.
I briefly show the first 2 and then focus on the third.

I will guide you through:
- How to register an app in Azure AD and create a service principal user
- How to set the permissions in AD and Power BI workspace so that the app also has rights to read the dataset
- How to get a token with which you then identify yourself at the WebAPI
- How to get a DAX query out of a Power BI report and insert it into Power Automate
- How to save the data to a Sharepoint list.
- And then integrate the data in a Power App
The session is based on an real project I recently finished.

Second application: Pausing and resuming Power BI Embedded capacity on Azure
I will show you how to use the above trick to pause and resume Power BI Embedded capacity on Azure in order to save money...

Ynte Jan Kuindersma

BIRD Automation

Groningen, The Netherlands

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top