# Power BI Modeling MCP Server: 21 tools, remote and local, from Microsoft

SERVER, read 10 Nov 2026

**The short answer.** Power BI Modeling MCP Server is an official MCP server for Power BI, published by Microsoft and read from its own source on 10 Nov 2026. It runs remote and local, and 21 tools are named. Version read: 1.0.1. Last release: 6 Nov 2026.

- **Data tool:** [Power BI](/mcp/power-bi/)
- **Publisher:** Microsoft
- **Kind:** Official
- **Repository or docs:** [github.com/microsoft/powerbi-modeling-mcp](https://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](https://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](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md).
- Scheduled metadata collection or lineage refresh in the Power BI Authoring MCP README or Learn page. [Source](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md).

## 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](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp), 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](https://github.com/microsoft/powerbi-modeling-mcp/releases), 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](https://registry.npmjs.org/@microsoft/powerbi-modeling-mcp), read 10 Nov 2026.)
- The local server is generally available and the hosted endpoint is in preview. (Microsoft's own claim; [source](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp), 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](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp), 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](https://learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overview), read 10 Nov 2026.)
- Microsoft states that clients operate under the user's Fabric RBAC permissions. (Microsoft's own claim; [source](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md), 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](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md), 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](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md), 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](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp), 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](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md), 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](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp), 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](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md), 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](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md), 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](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md), 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](https://learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overview), 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](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md), 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](https://raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md), 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](https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp), read 10 Nov 2026.)

## Read next

- [MCP servers for Power BI](/mcp/power-bi/): 1 listed
- [Power BI Modeling MCP Server and Tableau MCP, side by side](/compare/powerbi-modeling-mcp-vs-tableau-mcp/)
- [The Context Weight Index](/context-weight/)

## Sources

- learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp: https://learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp (read 10 Nov 2026)
- github.com/microsoft/powerbi-modeling-mcp/releases: https://github.com/microsoft/powerbi-modeling-mcp/releases (read 10 Nov 2026)
- registry.npmjs.org/@microsoft/powerbi-modeling-mcp: https://registry.npmjs.org/@microsoft/powerbi-modeling-mcp (read 10 Nov 2026)
- raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md: https://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: https://learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overview (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datamcpservers.com/servers/powerbi-modeling-mcp/
