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.
- Playwright MCP Playwright Tools for MCP ★ 36,436
- Azure MCP Server All Azure MCP tools to create a seamless connection between AI agents and Azure services. ★ 3,598
- Microsoft Fabric MCP Server MCP tools for interacting with Microsoft Fabric ★ 3,598
- Azure DevOps (ADO) The MCP server for Azure DevOps, bringing the power of Azure DevOps directly to your agents. ★ 1,977
- Awesome Copilot MCP Server An MCP server that stores Copilot customizations from the Awesome Copilot repository ★ 196
- Microsoft MCP Server for Enterprise Official Microsoft MCP Server to query Microsoft Entra data using natural language ★ 49
05 · Facts
- repository
- github.com/microsoft/powerbi-modeling-mcp
- 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
Alternatives to Power BI Modeling MCP Server
Maintained other servers if Power BI Modeling MCP Server isn't the fit.
- Heyputer MCP Server Puter MCP enables AI tools to interact with Puter: manage files, websites, workers, and more ★ 43,204 · 2026-08-24
- Server Commands An MCP server to run arbitrary commands ★ 38,704 · 2026-08-05
- Zotero MCP (54yyyu) Search, read, annotate, and add to your Zotero research library, local or web. ★ 4,780 · 2026-08-25
- Firebase MCP Gives AI development tools Firebase-specific capabilities and expertise. ★ 4,460 · 2026-08-25
- Microsoft Fabric MCP Server MCP tools for interacting with Microsoft Fabric ★ 3,598 · 2026-08-21
- Ship Swift 40+ production-ready SwiftUI recipes for building full-stack iOS apps via MCP. ★ 2,968 · 2026-08-09
More MCP servers to compare · Temporal MCP · AI CLI MCP · Clipboard MCP · Molpha MCP · MolTrust MCP Server