OAuth scopes
Sim requests these scopes when someone connects a Power BI account. For a self-hosted deployment, register your own app with the provider using the settings below. See Integrations and OAuth for setup.
Use the block
Connect a home-tenant organizational account through the Power BI Microsoft connection to list named workspaces, inspect reports and semantic models, execute DAX queries, request standard refreshes, and read refresh history. Microsoft Graph connections cannot substitute for this delegated OAuth connection. Self-hosted installations use the shared Microsoft app registration and register /api/auth/oauth2/callback/microsoft-powerbi as a Web redirect URI. Workspace listing supports a result limit, offset, and OData filter; reports and semantic models return flat lists. Read-only models may contain only their ID and name, and paginated reports may omit their semantic-model ID. Missing optional fields are null and do not establish permission or feature availability. Keep results small with summaries or TOPN: provider JSON reads are limited to 20 MiB, and workflow tool responses have a stricter 10 MiB inline budget. My Workspace, cross-tenant guest configuration, Credential Groups, service principals, impersonation, enhanced refresh, report exports, dashboards, and triggers are outside this version.
Actions
Power BI List Workspaces
List accessible Power BI workspaces with optional OData filtering and pagination.
Power BI List Reports
List reports in a Power BI workspace, including paginated reports.
Power BI Get Report
Get report metadata from a Power BI workspace.
Power BI List Semantic Models
List semantic models in a Power BI workspace; available metadata depends on permissions.
Power BI Get Semantic Model
Get semantic model metadata from a Power BI workspace.
Power BI Execute DAX Query
Execute one DAX query returning one table. Requires workspace access, Read/Build permissions, and the tenant Execute Queries setting. Reported errors fail the action even with HTTP 200. Direct tool responses retain partial rows and typed errors; failed workflows expose only the standard error output. Sim limits workflow tool responses to 10 MiB; use summaries or TOPN for larger results.
Power BI Refresh Semantic Model
Request a standard asynchronous semantic model refresh and return acceptance immediately. Acceptance does not mean completion; use Get Refresh History separately to inspect status. Shared capacity allows eight refresh requests per day, including scheduled refreshes.
Power BI Get Refresh History
Get recent semantic model refresh history; requires Write permission on the model. Unknown can mean a refresh is in progress or its completion state is unknown.