Query semantic models and manage reports and refreshes
Power BI is a Sim integration in the Analytics category. Sim is the AI workspace where teams build and deploy AI agents. Sim's Power BI integration provides 8 tools that AI agents can use inside Sim's visual workflow builder. Power BI connects with one-click OAuth. Free to start at sim.ai.
Last updated
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.
Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.
Open your workspace, drag a Power BI block onto the workflow builder, and connect your account with one-click OAuth.
Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Power BI automation is live.
Ready-to-use templates featuring Power BI. Click any to build it instantly.
8 Power BI tools available to Sim agents.
List accessible Power BI workspaces with optional OData filtering and pagination.
List reports in a Power BI workspace, including paginated reports.
Get report metadata from a Power BI workspace.
List semantic models in a Power BI workspace; available metadata depends on permissions.
Get semantic model metadata from a Power BI workspace.
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.
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.
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.
Sim's Power BI integration adds 8 tools to the AI agents you build in Sim's visual workflow builder. Query semantic models and manage reports and refreshes.
