Skip to main content

Power BI

The Power BI connection lets agents query your Power BI datasets through Power BI's own tools. It is added through the standard MCP connection and authorized with Microsoft OAuth, so there is no dedicated native module.

When to Use It​

Use it when an agent needs to run queries against Power BI datasets or bring Power BI results into a conversation or workflow, rather than exporting data to a file first.

Setup​

Power BI is added as an MCP connection.

  1. In Connections, click Add Connection and select MCP.
  2. Fill in:
    • Name: for example PowerBI.
    • Server URL: https://api.fabric.microsoft.com/v1/mcp/powerbi
  3. Click Continue and complete the Microsoft login to create the connection.
Recommended: disable GenerateQuery

After creating the connection, open its details and set the GenerateQuery function to Disabled. This function requires a Copilot licence, so if you do not have one, disabling it avoids confusing agents. Leave ExecuteQuery enabled.

Power BI MCP connection with the GenerateQuery function disabled

What the Tool Can Do​

The functions are published by the Power BI MCP server:

  • ExecuteQuery: run a query against a dataset the connected account can access.
  • GenerateQuery: generate a query from natural language. This requires a Copilot licence and is recommended to disable if you do not have one.

Security and Confirmation​

Queries run with the permissions of the account that completed the OAuth login: the connection can only reach the workspaces and datasets that account can. Governing individual functions works the same as for any MCP connection.

Example Use​

Run a query against the Sales dataset in Power BI and summarize revenue by region for this quarter.

Any execution can be reviewed in Run Tools.

Technical Notes​

  • Implementation: exposed through the standard MCP connection; the tool set is served at https://api.fabric.microsoft.com/v1/mcp/powerbi.
  • Authentication/scopes: OAuth through the Microsoft provider using auto-discovery, so the OAuth definition is provided by the tool. The connection uses the permissions of the signed-in account.
  • Functions: ExecuteQuery, and GenerateQuery (requires a Copilot licence; recommended to disable if unavailable).
Last updated on