# One MCP server for Power BI: Power BI Modeling MCP Server, from Microsoft

MCP SERVERS FOR A DATA TOOL, read 10 Nov 2026

**The short answer.** One MCP server for Power BI is listed: Power BI Modeling MCP Server, official, published by Microsoft and read on 10 Nov 2026. It runs remote and local and names 21 tools; the version read is 1.0.1. Last release: 6 Nov 2026. 21 sourced facts follow, each with its read date.

- **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

## Power BI Modeling MCP Server

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.

`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`

- None found on 10 Nov 2026: A lineage tool in the Power BI Authoring MCP tool table (no upstream-table, column-lineage or report-dependency tool).
- None found on 10 Nov 2026: Scheduled metadata collection or lineage refresh in the Power BI Authoring MCP README or Learn page.

## Read next

- [Power BI Modeling MCP Server, the full entry](/servers/powerbi-modeling-mcp/): 21 facts
- [Power BI Modeling MCP Server and Tableau MCP, side by side](/compare/powerbi-modeling-mcp-vs-tableau-mcp/)
- [BI and analytics](/categories/bi/)

## 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)
- 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)
- 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)

Last reviewed 10 Nov 2026. Canonical: https://datamcpservers.com/mcp/power-bi/
