Microsoft Power BI
Microsoft Power BI connector for workspaces, reports, semantic models, dashboards, dataflows and tenant administration through the Power BI REST API.
Categories: Analytics, Business Intelligence, Productivity
What you can ask
- Refresh the
Sales Pipelinesemantic model and check the refresh history for failures - List every report in the
Financeworkspace and who has access to the workspace - Push rows into a push dataset for a live operations dashboard
Set up
Microsoft Power BI needs an OAuth application from your organization before anyone can connect. An organization admin completes these steps once.
- Go to Organization > Connectors and find Microsoft Power BI. Click Enable, and choose which tools to allow.
- Create an OAuth application in the Microsoft Power BI developer portal.
- Add the Redirect URI shown in the connector settings to the application.
- Copy the application's Client ID and Client Secret into the connector, then save it.
- Each member connects their own account the first time they use it.
⚠️ Warning: Do not enter your Devs.ai or Microsoft Power BI login email or password in the OAuth application fields.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
OAuth scopes used by these tools (10)
Grant the scopes for the tools you plan to allow.
https://analysis.windows.net/powerbi/api/App.Read.Allhttps://analysis.windows.net/powerbi/api/Content.Createhttps://analysis.windows.net/powerbi/api/Dashboard.ReadWrite.Allhttps://analysis.windows.net/powerbi/api/Dataflow.ReadWrite.Allhttps://analysis.windows.net/powerbi/api/Dataset.ReadWrite.Allhttps://analysis.windows.net/powerbi/api/Gateway.Read.Allhttps://analysis.windows.net/powerbi/api/Report.ReadWrite.Allhttps://analysis.windows.net/powerbi/api/Tenant.Read.Allhttps://analysis.windows.net/powerbi/api/Workspace.Read.Allhttps://analysis.windows.net/powerbi/api/Workspace.ReadWrite.All
Tools
Microsoft Power BI offers 42 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (30)
View and search information without changing it.
| Tool | What it does |
|---|---|
get_app | Get one Power BI app by ID. |
get_dashboard | Get one dashboard by ID. |
get_dataflow | Get a Power BI (Gen1) dataflow's stored definition, containing its entities and Power Query expressions. |
get_dataset | Get one semantic model by ID. |
get_dataset_datasources | List the data sources a semantic model reads from, including the gateway serving each one. |
get_gateway | Get one on-premises data gateway by ID. |
get_import | Get one import by ID to check its progress. import_state reads 'Publishing' while it runs and 'Succeeded' when the reports and semantic models it created become available. |
get_refresh_history | List past and in-progress refreshes of a semantic model, newest first. |
get_report | Get one report by ID, including the semantic model it reads from. |
get_workspace | Get one Power BI workspace by ID. |
list_admin_dashboards | List every dashboard in the tenant, across all workspaces. |
list_admin_dataflows | List every dataflow in the tenant, across all workspaces. |
list_admin_datasets | List every semantic model in the tenant, across all workspaces. |
list_admin_reports | List every report in the tenant, across all workspaces. |
list_admin_workspaces | List every workspace in the tenant, including ones the account is not a member of. |
list_app_dashboards | List the dashboards published inside a Power BI app. |
list_app_reports | List the reports published inside a Power BI app. |
list_apps | List the Power BI apps the connected account can open. |
list_dashboard_tiles | List the tiles pinned to a dashboard, including the report and semantic model behind each one. |
list_dashboards | List the dashboards in a Power BI workspace. |
list_dataflows | List the Power BI (Gen1) dataflows in a workspace. |
list_dataset_tables | List the table names in a push semantic model. |
list_datasets | List the semantic models (datasets) in a Power BI workspace. |
list_gateway_datasources | List the data sources bound to an on-premises data gateway. |
list_gateways | List the on-premises data gateways the connected account can administer. |
list_imports | List the .pbix and Excel imports performed into a Power BI workspace, with the state of each. |
list_reports | List the reports in a Power BI workspace. |
list_workspace_users | List the users, groups and service principals with access to a Power BI workspace, and the access level each holds. |
list_workspaces | List the Power BI workspaces the connected account can open. |
validate_credential | Validate Power BI credentials by reading the tenant's available features. |
Write (7)
Create or send data.
| Tool | What it does |
|---|---|
add_workspace_user | Grant a user, group or service principal access to a Power BI workspace. |
clone_report | Copy a report, optionally into another workspace or onto another semantic model. |
create_dashboard | Create an empty dashboard in a Power BI workspace. |
create_push_dataset | Create a push semantic model from a table schema, with no .pbix file. |
create_workspace | Create a Power BI workspace. |
push_rows | Append rows to a table in a push semantic model. |
refresh_dataset | Start a refresh of a semantic model. |
Delete or overwrite (5)
Remove or replace existing data.
| Tool | What it does |
|---|---|
delete_dataset | Delete a semantic model and every report built on it. |
delete_report | Delete a report from a Power BI workspace. |
delete_workspace | Delete a Power BI workspace and everything inside it. |
remove_workspace_user | Revoke a principal's access to a Power BI workspace. |
truncate_table | Delete every row from a table in a push semantic model, leaving the table and its schema in place. |