Power BI Modeling MCP Server

The Power BI Modeling MCP Server implements the MCP specification to create a seamless connection between AI agents and Power BI semantic models. This project is in Public Preview and implementation may significantly change prior to our General Availability. Its 21 documented tools cover operations, group. It runs locally over stdio via the published package.

People connecting this server to Claude, Cursor, VS Code, or another MCP client.

VERIFIED ACTIVE

LAST COMMIT 2026-08-19 · ★ 1,092 · #7 OF 848 MAINTAINED OTHER · VERIFIED 2026-08-25

MIT · how we verify → /methodology

01 · Install Power BI Modeling MCP Server

before you install - you'll need

Set PBI_MODELING_MCP_ACCESS_TOKEN before connecting.

Claude Code

claude mcp add microsoft-powerbi-modeling-mcp -- npx -y @microsoft/powerbi-modeling-mcp

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "microsoft-powerbi-modeling-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp"
      ]
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions

license MIT - declared in the repository

npm package @microsoft/powerbi-modeling-mcp - published under the repo owner's npm scope (@microsoft)

registry vendor namespace com.microsoft - domain-verified with the official MCP registry

03 · What Power BI Modeling MCP Server can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

What you can build

With this server connected, an agent can connect to Power BI Desktop or Fabric workspaces, manage semantic models - connect, create, update, list databases, import/export TMDL folders, deploy to Fabric, control database transactions (begin, commit, rollback, get status), and manage tables (create, update, delete, get, list, refresh, rename).

Capability map

Tools grouped from the project's README - what Power BI Modeling MCP Server lets an agent do.

Connection

1 tool - e.g. Connect to Power BI Desktop or Fabric workspaces

connection_operations

Database

1 tool - e.g. Manage semantic models - connect, create, update, list databases, import/export TMDL folders, deploy to Fabric

database_operations

Transaction

1 tool - e.g. Control database transactions (begin, commit, rollback, get status)

transaction_operations

Model

1 tool - e.g. Work with the overall model (get, create, update, refresh, get stats, rename)

model_operations

Table

1 tool - e.g. Manage tables (create, update, delete, get, list, refresh, rename)

table_operations

Column

1 tool - e.g. Manage individual table columns (create, update, delete, get, list, rename)

column_operations

Measure

1 tool - e.g. Manage individual DAX measures (create, update, delete, get, list, rename, move between tables)

measure_operations

Relationship

1 tool - e.g. Handle relationships between tables (create, update, delete, activate/deactivate, find)

relationship_operations

04 · Who maintains Power BI Modeling MCP Server

Power BI Modeling MCP Server is maintained by microsoft. We track 9 MCP servers from microsoft - 9 actively maintained, 43,350 combined GitHub stars, oldest repo from Mar 2025. Full record: all servers from microsoft.

  1. Playwright MCP Playwright Tools for MCP ★ 36,436
  2. Azure MCP Server All Azure MCP tools to create a seamless connection between AI agents and Azure services. ★ 3,598
  3. Microsoft Fabric MCP Server MCP tools for interacting with Microsoft Fabric ★ 3,598
  4. Azure DevOps (ADO) The MCP server for Azure DevOps, bringing the power of Azure DevOps directly to your agents. ★ 1,977
  5. Awesome Copilot MCP Server An MCP server that stores Copilot customizations from the Awesome Copilot repository ★ 196
  6. Microsoft MCP Server for Enterprise Official Microsoft MCP Server to query Microsoft Entra data using natural language ★ 49

05 · Facts

category
other - ranked #7 of 848 actively-maintained other servers as of 2026-08-25.
registry
com.microsoft/powerbi-modeling-mcp (active, first published 2026-06-03 · 4 versions)
packages
npm:@microsoft/powerbi-modeling-mcp

06 · Power BI Modeling MCP Server FAQ

Is Power BI Modeling MCP Server still maintained?

Yes - as of 2026-08-25, its last commit was 2026-08-19. We re-verify nightly.

What can Power BI Modeling MCP Server do?

With this server connected, an agent can connect to Power BI Desktop or Fabric workspaces, manage semantic models - connect, create, update, list databases, import/export TMDL folders, deploy to Fabric, control database transactions (begin, commit, rollback, get status), and manage tables (create, update, delete, get, list, refresh, rename).

How do I install Power BI Modeling MCP Server?

Run `npx -y @microsoft/powerbi-modeling-mcp`. The README documents one environment variable (PBI_MODELING_MCP_ACCESS_TOKEN) to set first. Set PBI_MODELING_MCP_ACCESS_TOKEN before connecting. You can also paste the ready-made client config above.

Does Power BI Modeling MCP Server run locally?

Yes - it's a stdio server: it runs on your machine (via npx) with your user's permissions. Your data stays local unless the server itself calls external APIs.

07 · Alternatives to Power BI Modeling MCP Server

More MCP servers to compare · Temporal MCP · AI CLI MCP · Clipboard MCP · Molpha MCP · MolTrust MCP Server