Business Intelligence - Microsoft Power BI

Modified on Mon, 12 Aug at 2:59 PM

With Microsoft Power BI modules in Make, you can manage the apps, dashboards, and reports in your Microsoft Power BI account.

To use the Microsoft Power BI modules, you must have a Microsoft Power BI account. You can create an account at signup.microsoft.com/create-account/signup.

Refer to the Microsoft Power BI API documentation for a list of available endpoints.

Connect Microsoft Power BI to Make

To establish the connection in Make:

  1. Log in to your Make account, add a Microsoft Power BI module to your scenario, and click Create a connection.

  2. Optional: In the Connection name field, enter a name for the connection.

  3. Optional: Click Show advanced settings and enter your custom app client credentials. For more information, refer to the Microsoft Power BI custom credentials documentation.

    If requested, use the following Redirect URI when creating your custom app: https://www.integromat.com/oauth/cb/microsoft-power-bi

  4. Click Save.

  5. If prompted, authenticate your account and confirm access.

You have successfully established the connection. You can now edit your scenario and add more Microsoft Power BI modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.

Build Microsoft Power BI Scenarios

After connecting the app, you can perform the following actions:

Dashboard

  • List Dashboards

  • List Dashboard Tiles

  • Get a Dashboard

  • Get a Dashboard Tile

  • Create a Dashboard

Report

  • List Reports

  • Get a Report

  • Copy a Report

  • Delete a Report

Dataset

  • List Datasets

  • List Dataset Users

  • Get a Dataset

  • Create a Dataset

  • Add/Delete Rows in a Dataset Table

  • Refresh a Dataset

  • Delete a Dataset

App

  • Watch Apps

  • List Apps

  • List App's Reports

  • List App's Dashboards

  • Get an App

  • Get an App Report

  • Get an App's Dashboard

Other

  • Make an API Call

  • Add/Delete Rows in a Dataset Table: Dataset.ReadWrite.All, Workspace.Read.All

  • Copy a Report: Report.Read.All, Workspace.Read.All, Content.Create

  • Create a Dashboard: Dashboard.Read.All, Content.Create, Workspace.Read.All

  • Create a Dataset: Dataset.ReadWrite.All, Workspace.Read.All

  • Delete a Dataset: Dataset.ReadWrite.All, Workspace.Read.All

  • Delete a Report: Report.ReadWrite.All, Workspace.Read.All

  • Get a Dashboard: Dataset.Read.All, Workspace.Read.All

  • Get a Dashboard Tile: Dashboard.Read.All, Workspace.Read.All

  • Get a Dataset: Dataset.Read.All, Workspace.Read.All

  • Get an App: App.Read.All

  • Get an App’s Dashboard: Dashboard.Read.All, App.Read.All

  • Get an App’s Report: Report.Read.All, App.Read.All

  • Get a Report: Report.Read.All, App.Read.All

  • List Apps: App.Read.All

  • List App’s Dashboards: Dashboard.Read.All, App.Read.All

  • List App’s Reports: Report.Read.All, App.Read.All

  • List Dashboards: Dashboard.Read.All, Workspace.Read.All

  • List Dashboard Tiles: Dashboard.Read.All, Workspace.Read.All

  • List Datasets: Dataset.Read.All, Workspace.Read.All

  • List Dataset Users: Dataset.Read.All, Workspace.Read.All, Tenant.Read.All

  • List Reports: Report.Read.All, Workspace.Read.All

  • Make an API Call: Dataset.ReadWrite.All, Workspace.ReadWrite.All, Dashboard.ReadWrite.All, Report.ReadWrite.All, Capacity.ReadWrite.All, Dataflow.ReadWrite.All, App.Read.All

  • Refresh a Dataset: Dataset.ReadWrite.All, Workspace.Read.All

  • Watch Apps: App.Read.All

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

Preview
0 of 0