Power BI MCP connects Claude to semantic models
Power BI’s MCP connection lets Claude query an existing semantic model and use its measures to generate interactive dashboards.
Key insights
- Claude can query a Power BI semantic model instead of relying on an exported data file.
- The integration can reuse existing model tables, relationships, and DAX measures.
- Setup notes call for an administrator-enabled MCP tenant setting and model query permissions.
- The research describes the integration as a preview and Claude Dashboards as beta.
Power BI’s Model Context Protocol (MCP) connection lets Claude query an existing semantic model and use its data and measures to build interactive dashboards. It may interest Power BI users and analysts who want to prototype dashboard views using natural-language requests while reusing model definitions. How to Power BI is the publisher associated with the demonstration, but the supplied Short has no transcript or further description.
What it does
A Power BI semantic model holds the tables, relationships, measures, and calculations that reports can use. The MCP server acts as a connection between that model and a compatible AI client, allowing Claude to inspect model information or run queries and work with the returned results.
In this setup, Claude can use existing DAX measures rather than independently recreating every metric. The research describes a flow in which Claude queries the model and then assembles charts, KPI cards, written observations, and interactive dashboard elements. The model remains the analytical source; Claude provides a conversational way to explore it and draft a dashboard.
This is different from asking an AI tool to make charts from a spreadsheet export: the intended approach uses the model’s existing structure and business definitions. It does not, by itself, establish that a generated dashboard is a governed Power BI report.
Who it is for and what you need
The setup described is for people with access to a Power BI or Microsoft Fabric environment, a semantic model, and permission to query it. The research says an administrator must enable the Power BI MCP tenant setting and that an Entra application registration and delegated permissions are part of the setup.
It also describes configuring a custom MCP connector in Claude and supplying the semantic model identifier. The research characterizes the Power BI MCP integration as a preview and Claude Dashboards as beta. It does not specify eligible license names, regional availability, or a precise menu path for the tenant setting.
How it works
- An administrator enables the Power BI MCP tenant setting, subject to organizational approval.
- Configure the Entra application and delegated permissions, then set up a custom MCP connector in Claude.
- Provide the semantic model identifier so Claude can inspect the model or query it through the MCP connection.
- Ask Claude to create or revise a dashboard using the model’s available data and measures.
The research gives as the reported model-querying endpoint. It also mentions permissions such as and ; organizations should assess the permissions needed for their own configuration.
Limitations and open questions
The supplied Short transcript is empty, so it does not verify a hands-on sequence or particular result. The research does not specify license requirements, regions, or exact setting navigation. Confirm these details against current product documentation before planning a deployment.
Generated dashboards should be treated as drafts until queries, results, access controls, and sharing are reviewed. The notes specifically flag validation and governance, including checking whether the underlying connection enforces row-level security. They also caution against exposing confidential results through shared Claude artifacts.
Sources
- Power BI MCP endpoint listed in the research notes
- How to Power BI YouTube Short
- How to Power BI website
For related reporting coverage, see Power BI topics.
Frequently asked questions
Can Claude use existing Power BI DAX measures?
The research describes Claude querying a Power BI semantic model and reusing its existing measures. It does not provide a transcript confirming a particular measure or query.
What is required to connect Claude to a Power BI model?
The described setup includes a semantic model, permission to query it, an administrator-enabled Power BI MCP tenant setting, an Entra application registration, and a custom MCP connector in Claude.
Is the Power BI MCP integration generally available?
The research notes describe the integration as in preview and Claude Dashboards as beta. They do not specify license eligibility or regional availability.
Does Claude-generated output count as a governed Power BI report?
Not automatically. The research recommends reviewing queries, results, permissions, and sharing before relying on generated dashboards.