Business Intelligence
Microsoft Power BI
5min
With Microsoft Power BI modules in , 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.
To establish the connection in :
- Log in to your account, add a Microsoft Power BI module to your , and click Create a connection.
- Optional: In the Connection name field, enter a name for the connection.
- Optional: Click Show advanced settings and enter your custom app client credentials. For more information, refer to the Microsoft Power BI custom credentials documentation.
- Click Save.
- If prompted, authenticate your account and confirm access.
You have successfully established the connection. You can now edit your and add more Microsoft Power BI modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.
- Add/Delete Rows in a Dataset Table: Dataset.ReadWrite.All, Workspace.Read.All
- Create a Connection: Offline_access, User.Read, Openid
- 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
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