Power BI MCP connects Claude to semantic models
Power BI’s preview MCP server lets Claude query a semantic model and build an interactive dashboard using its existing model logic.
Key insights
- The Power BI MCP server is described as a preview capability.
- Claude can query tables and measures in a Power BI semantic model through the MCP endpoint.
- The approach keeps model definitions and DAX measures in Power BI while Claude generates a separate presentation layer.
- The described setup uses Microsoft Entra authentication and may require supplying a semantic model ID.
Power BI’s Model Context Protocol (MCP) server can connect Claude to a semantic model so Claude can query its data and generate an interactive dashboard. This approach is relevant to Power BI model owners and analysts who want to prototype another interface without rebuilding the model’s measures and relationships. How to Power BI’s demonstration is the source for the dashboard-building topic, while the available transcript contains no spoken or shown steps to verify.
What it does
The integration separates the model from the dashboard interface. Power BI continues to hold the semantic model’s tables, relationships, and DAX measures; Claude uses the MCP connection to inspect and query that model, then produces a browser-based dashboard from the results.
A semantic model is the organized analytical layer behind Power BI reporting. Its measures encode calculations, such as business metrics, and its relationships define how tables work together. Reusing those existing definitions can help keep an AI-generated dashboard aligned with the organization’s model logic, rather than asking Claude to recreate calculations from exported data.
The research notes describe Claude dashboards as beta artifacts and the Power BI MCP server as a preview capability. The proposed outcome can include KPI cards, charts, filters, and written explanations, but the materials do not verify that every dashboard type or feature works in every environment.
Who it is for and what you need
This approach is aimed at teams that already have a Power BI semantic model and want to explore a conversationally generated dashboard. The notes describe a tenant setting for the Power BI MCP server, a Microsoft Entra application registration, delegated permissions, and a Claude connector configured with the Power BI MCP endpoint.
The exact licensing, tenant availability, region, and final permission requirements are not stated in the available material. The notes characterize the server as preview and say requirements may change. An administrator should check the organization’s configuration before treating the described setup as generally available.
How it works
- A Power BI administrator enables the tenant setting named “Users can use the Power BI Model Context Protocol server endpoint (preview),” as described in the research notes.
- Configure Microsoft Entra authentication and the Claude connector. The notes identify the endpoint as the Power BI MCP endpoint and name delegated permissions used in a reported setup.
- Provide access to the intended semantic model. The notes say the model ID may need to be supplied manually because finding a model by display name may not be available through the server.
- Ask Claude to inspect the model’s tables, relationships, and measures before requesting a dashboard. Specify the metrics and views needed, and ask it to use existing DAX measures where possible.
Limitations and open questions
The available Short description contains no substantive setup instructions, and its transcript is empty. The configuration details here come from the supplied research notes, not a verifiable walkthrough, so treat them as a reported workflow rather than a universal deployment guide.
The notes also do not establish feature coverage, licensing, or whether access controls behave identically to Power BI reports. Confirm those details with your administrators and current Microsoft documentation before using the connection with business data. For broader reporting context, see more Power BI coverage.
Sources
Frequently asked questions
Can Claude connect to a Power BI semantic model?
The research notes describe a connection through Microsoft’s Power BI MCP server. They say the workflow uses Microsoft Entra authentication and a Claude connector.
Is the Power BI MCP server generally available?
The supplied notes describe it as a preview capability. They do not establish availability across tenants, regions, or licenses.
Does Claude need to recreate Power BI measures?
The described workflow can use existing DAX measures in the semantic model. The notes recommend asking Claude to use those measures, but do not guarantee how every query will be handled.
What information may I need to connect Claude to a model?
The notes describe an Entra app registration, delegated permissions, the MCP endpoint, and access to the model. They say the semantic model ID may need to be supplied manually.