Official server by Microsoft
Power BI Modeling (Authoring) MCP server
Create and change Power BI semantic models: tables, measures, relationships, security roles and DAX, with TMDL and PBIP files.
Install
Pick your agent and copy one line. Remote servers ask you to sign in on first use.
claude mcp add power-bi-modeling -- npx -y @microsoft/powerbi-modeling-mcp --start
# ~/.codex/config.toml [mcp_servers.power_bi_modeling] command = "npx" args = ["-y", "@microsoft/powerbi-modeling-mcp", "--start"]
gemini mcp add power-bi-modeling npx -y @microsoft/powerbi-modeling-mcp --start
{
"mcpServers": {
"power-bi-modeling": {
"command": "npx",
"args": [
"-y",
"@microsoft/powerbi-modeling-mcp",
"--start"
]
}
}
}code --add-mcp '{"name":"power-bi-modeling","command":"npx","args":["-y","@microsoft/powerbi-modeling-mcp","--start"]}'What it can do
From Microsoft's own MCP documentation.
Sign in
Microsoft Entra ID interactive sign-in, or a service principal. Operations run with the signed-in user's Fabric permissions.
Options
- The local server is generally available and runs over stdio. Install from the VS Code extension, npx @microsoft/powerbi-modeling-mcp --start, or a standalone executable.
- A hosted version (preview) runs at https://api.fabric.microsoft.com/v1/mcp/powerbi/authoring.
- Only the local server supports Power BI Desktop, PBIP files on disk, service principal sign-in, transactions and traces.
- Tools are grouped by object type (tables, columns, measures, relationships). The full list is in the GitHub repo.
Good to know
- The local server does not support macOS. Use the hosted server on a Mac.
- It only does modeling. It cannot change report pages or diagram layouts.
- DAX query tools have a hard limit of 100,000 rows.
- Needs Write or Build permission on the model. With only Build it can just run DAX queries. Fabric workspace models need the XMLA endpoint set to Read Write.
- Do not register the local and hosted servers together, since the overlapping tools confuse routing and cost tokens.
- Not meant for answering business questions. Microsoft points to Fabric IQ for that.
- Back up the model first, ideally as PBIP files in Git.
Details
- Registry name
- com.microsoft/powerbi-modeling-mcp
- Latest version
- 1.0.1 (updated 2026-11-06)
- Packages
@microsoft/powerbi-modeling-mcp (npm)
- Links
- Microsoft docsSource
More in Product analytics
Reviewed Oct 21, 2026. Official means published under Microsoft's namespace in the MCP registry. It is not a security audit.
Built an MCP server? Get it listed everywhere →
Shipping an Android app? Google Play needs 12 testers for 14 days first. Get them with Tester Exchange →