Power BI

Connect Power BI to Formula Bot to analyze semantic models with DAX and use the results in AI analysis, charts, and dashboards. Formula Bot also syncs the reports and dashboards you can access so you can browse the surrounding BI catalog.

Before users can query data, a Power BI administrator must enable Semantic Model Execute Queries REST API in Tenant settings → Integration settings. Microsoft previously called this Dataset Execute Queries REST API. Without it, Formula Bot shows “Your Power BI administrator must enable the Semantic Model Execute Queries REST API tenant setting.”

Requirements

A Power BI account in a Microsoft organizational tenant
Access to the workspace or semantic model you want to analyze
Read and Build permission on each semantic model you want to query
The tenant setting described above enabled for the connected user
Permission to approve Formula Bot's delegated, read-only Power BI OAuth scopes

Connect Power BI

Switch to your personal workspace in Formula Bot.
Go to Connectors, then Power BI.
Select Continue with Microsoft. Complete Microsoft authorization in the popup.
Return to Formula Bot and choose the authorized Power BI account.
Enter an optional connector name, then select Create connector.
Select Sync assets to load the workspaces, semantic models, reports, and dashboards available to that account.
Select Start chatting to attach the connector to a new chat.

Formula Bot stores delegated OAuth credentials securely and refreshes them when needed. The browser receives only sanitized connection and connector details, never access or refresh tokens.

What's supported

Power BI content	Support
Semantic models (datasets)	Queryable with DAX through the Execute Queries REST API
Workspaces	Synced for organization and browsing
Reports	Listed as secondary metadata; not queried directly
Dashboards	Listed as secondary metadata; not queried directly
My Workspace	Synced separately, including its available semantic models

Formula Bot can aggregate, filter, and group semantic-model data with DAX, analyze the returned rows, and create Formula Bot charts and dashboards from those results. It does not edit Power BI semantic models, reports, or dashboards.

Query limits

Each Power BI Execute Queries request is limited to:

100,000 rows
1,000,000 values
15 MB of result data
One result table per query

If a result is too large, narrow it with filters, TOPN, or aggregation in DAX. Formula Bot rejects oversized or partial results instead of saving incomplete data.

Some semantic models are not supported by the REST query API, including Azure Analysis Services live connections. Power BI also limits request frequency; if Microsoft rate-limits a request, wait briefly and retry.

Personal-only access

Power BI connectors are available only in Formula Bot personal workspaces. Delegated OAuth and Power BI row-level security use the connected person's identity, so sharing one user's connector with a team could expose the wrong security view. Team-shared Power BI connections are not supported in this release.

Refresh synced assets

Use Sync assets on the connector page whenever Power BI workspaces or content change. The setup page shows the sync status and last successful sync time. Expanding the connector in chat loads the stored snapshot; it does not make a live Power BI request.

Reports and dashboards help identify the content surrounding a semantic model, but only semantic models are queryable.

Troubleshooting

“Your Power BI administrator must enable the Semantic Model Execute Queries REST API tenant setting.”

Ask a Power BI administrator to open the Power BI admin portal, go to Tenant settings → Integration settings, and enable Semantic Model Execute Queries REST API for your user or security group. In older Microsoft documentation, look for Dataset Execute Queries REST API.

“This Power BI account needs Build permission on the semantic model to run queries.”

Ask the semantic-model owner or workspace administrator for Build permission. Read access by itself is not sufficient for Execute Queries.

“This Power BI semantic model does not support DAX queries through the REST API.”

The model may use an unsupported connection type, such as an Azure Analysis Services live connection. Choose another semantic model or change its Power BI connection architecture.

“Power BI authorization has expired or is no longer valid.” or “Reconnect Power BI to continue.”

Open the Power BI connector page and choose Reconnect. Reauthorize with the same Microsoft account; account substitution is rejected during reconnect.

“The Power BI query result is too large.”

Ask a narrower question or add DAX filters and aggregation. Keep the result below 100,000 rows, 1,000,000 values, and 15 MB.

“Power BI is temporarily rate limiting requests.”

Wait a moment and retry. If the problem continues, reduce concurrent queries or refreshes.

No workspaces or semantic models appear

Confirm the connected Microsoft account can access the expected Power BI content.
Confirm the account has Build permission on the semantic model.
Select Sync assets again after permissions change.
Content shared directly or installed through a Power BI app may be grouped outside normal workspaces.

“Power BI connectors are available only in personal workspaces.”

Switch to your Formula Bot personal workspace and create the connector there. Team Power BI connectors are not supported in this release.