Power BI Authoring MCP Server (Local) - install & status [2026]

01 · Install Power BI Authoring MCP Server (Local)

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 Authoring MCP Server (Local) 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 Authoring MCP Server (Local) 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

Latest releases

v1.0.0 · 2026-09-25

Other Changes · Update EULA to GA version

04 · Who maintains Power BI Authoring MCP Server (Local)

Power BI Authoring MCP Server (Local) is maintained by microsoft. We track 9 MCP servers from microsoft - 9 actively maintained, 44,911 combined GitHub stars, oldest repo from Mar 2025. Full record: all servers from microsoft.

05 · Facts

repository: github.com/microsoft/powerbi-modeling-mcp
category: other - ranked #4 of 998 actively-maintained other servers as of 2026-09-30.
release cadence: 1 release in the last 90 days (latest 2026-09-25)
registry: com.microsoft/powerbi-modeling-mcp (active, first published 2026-06-03 · 9 versions)
packages: npm:@microsoft/powerbi-modeling-mcp

06 · Power BI Authoring MCP Server (Local) FAQ

Is Power BI Authoring MCP Server (Local) still maintained?

Yes - as of 2026-09-30, its last commit was 2026-09-29 and it shipped 1 release in the last 90 days. We re-verify nightly.

What can Power BI Authoring MCP Server (Local) 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 Authoring MCP Server (Local)?

Run `npx -y @microsoft/powerbi-modeling-mcp`. You can also paste the ready-made client config above.

Does Power BI Authoring MCP Server (Local) 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 Authoring MCP Server (Local)

Alternatives to Power BI Authoring MCP Server (Local)

Maintained other servers if Power BI Authoring MCP Server (Local) isn't the fit.

More MCP servers to compare · Velog (milcho0604) · Mind the Product · Temporal MCP · Canonic · AI CLI MCP