Skip to content
Data MCP Directory

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

Sources

  1. learn.microsoft.com/en-us/power-bi/developer/mcp/power-bi-authoring-mcp, read 10 Nov 2026
  2. github.com/microsoft/powerbi-modeling-mcp/releases, read 10 Nov 2026
  3. registry.npmjs.org/@microsoft/powerbi-modeling-mcp, read 10 Nov 2026
  4. raw.githubusercontent.com/microsoft/powerbi-modeling-mcp/main/README.md, read 10 Nov 2026
  5. learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overview, read 10 Nov 2026

Last reviewed 10 Nov 2026.