SERVER, read 10 Nov 2026
Power BI Modeling MCP Server: 21 tools, remote and local, from Microsoft
MCP servers for Power BIBack to the directory
- Data tool
- Power BI
- Publisher
- Microsoft
- Kind
- Official
- Repository or docs
- github.com/microsoft/powerbi-modeling-mcp
- Version or commit
- 1.0.1
- Last release
- 6 Nov 2026
- Transport
- Remote and local
- Auth
- Local: Microsoft Entra interactive sign-in (default) or service principal (client secret or certificate). Hosted: Entra ID as the signed-in user.
- Access
- Configurable
- Tools listed
- 21 named in the evidence
- Tool definitions read at
- raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md
- Context weight
- 387 tokens for 21 tool definitions (21 with a description), measured from the README read
- Status
- Exists on 10 Nov 2026. Microsoft documents two Power BI MCP servers: the Authoring server (local GA over stdio from microsoft/powerbi-modeling-mcp, hosted preview at api.fabric.microsoft.com/v1/mcp/powerbi/authoring and Fabric IQ for answering questions over governed data; an earlier consumption MCP remains documented. Hosted authoring tool names are not published, so the tool list is the local server's.
- Read
- 10 Nov 2026
In one sentence
Microsoft's authoring server reads and writes semantic-model objects (tables, columns, DAX measures, relationships, RLS roles, TMDL) under the user's Fabric permissions, with a read-only switch.
What Power BI Modeling MCP Server exposes
21 tools are named in the evidence read on 10 Nov 2026.
connection_operations database_operations transaction_operations model_operations table_operations column_operations measure_operations relationship_operations dax_query_operations trace_operations partition_operations user_hierarchy_operations calculation_group_operations security_role_operations perspective_operations named_expression_operations function_operations culture_operations object_translation_operations calendar_operations query_group_operations
Not found in the sources read
- A lineage tool in the Power BI Authoring MCP tool table (no upstream-table, column-lineage or report-dependency tool). Source.
- Scheduled metadata collection or lineage refresh in the Power BI Authoring MCP README or Learn page. Source.
The evidence on Power BI Modeling MCP Server, by topic
Publisher and releases
- Microsoft publishes the Power BI Authoring MCP Server in its own microsoft GitHub organization and documents it on Microsoft Learn. (Microsoft's own claim; source, read 10 Nov 2026.)
- The latest GitHub release is v1.0.1 (previous v1.0.0, then beta tags), timestamped 6 Nov 2026. (observed in the source; source, read 10 Nov 2026.)
- The npm package @microsoft/powerbi-modeling-mcp has latest 1.0.1 published 6 Nov 2026, and 1.0.0 on 25 Sep 2026. (observed in the source; source, read 10 Nov 2026.)
- The local server is generally available and the hosted endpoint is in preview. (Microsoft's own claim; source, read 10 Nov 2026.)
Clients, auth and scoping
- The hosted server prompts for Microsoft Entra sign-in on first tool call and then acts with the user's permissions. (Microsoft's own claim; source, read 10 Nov 2026.)
- Fabric IQ, Microsoft's consumption server, answers questions over semantic models and respects permissions, row-level security and object-level security. (Microsoft's own claim; source, read 10 Nov 2026.)
- Microsoft states that clients operate under the user's Fabric RBAC permissions. (Microsoft's own claim; source, read 10 Nov 2026.)
Access and safety
- The --readonly option is described as safe mode that prevents any write operations to the semantic model; --readwrite is the default with a confirmation prompt. (Microsoft's own claim; source, read 10 Nov 2026.)
- Blocking access requires disabling the XMLA endpoint because no tenant admin setting specifically blocks this server. (Microsoft's own claim; source, read 10 Nov 2026.)
- With only Build permission the server can only run DAX queries; Write permission is needed to change model objects. (Microsoft's own claim; source, read 10 Nov 2026.)
What it reaches
- The local server connects to semantic models in Power BI Desktop, Fabric workspaces and Power BI Project (PBIP) files; --compatibility Full also targets Analysis Services databases. (Microsoft's own claim; source, read 10 Nov 2026.)
- Hosted uses Streamable HTTP and Entra ID; local uses stdio, with Desktop, PBIP files, transactions and traces only on local. (Microsoft's own claim; source, read 10 Nov 2026.)
Lineage and impact
- The server exposes model-object tools for tables, columns, measures, relationships, partitions, hierarchies, calculation groups and named expressions (model definition level). (Microsoft's own claim; source, read 10 Nov 2026.)
- Database_operations can import and export TMDL folders and deploy to Fabric, giving agents the model definition as code. (Microsoft's own claim; source, read 10 Nov 2026.)
Definitions, ownership and rules
- Tools manage security roles with row-level security, perspectives, cultures and object translations, which are governance and meaning objects inside the model. (Microsoft's own claim; source, read 10 Nov 2026.)
- The server can evaluate a model against a set of modeling practice rules and generate documentation for an existing model. (Microsoft's own claim; source, read 10 Nov 2026.)
Freshness and upkeep
- The server connects to semantic models through the XMLA endpoint, so it reads and writes the live model rather than a collected copy. (Microsoft's own claim; source, read 10 Nov 2026.)
Profile
- Use of the software is subject to the Power BI Authoring MCP Server EULA, and NPX installs require explicit acceptance. (Microsoft's own claim; source, read 10 Nov 2026.)
- Microsoft advises the hosted server for Fabric workspaces and not registering both local and remote at once. (Microsoft's own claim; source, read 10 Nov 2026.)
Read next
Sources
- learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp, read 10 Nov 2026
- github.com/microsoft/powerbi-modeling-mcp/releases, read 10 Nov 2026
- registry.npmjs.org/@microsoft/powerbi-modeling-mcp, read 10 Nov 2026
- raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md, read 10 Nov 2026
- learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overview, read 10 Nov 2026
Last reviewed 10 Nov 2026.