Power BI Modeling MCP Server

Name: Power BI Modeling MCP Server Review
Item: Power BI Modeling MCP Server
Rating: 4.0
Author: Aaron Matthews

Connector Data & Analytics Solid

Works inClaude Code Claude Cowork Claude Chat

Solid Scanned — metadata only

Enables AI-assisted BI development in Power BI and Microsoft Fabric. Azure Identity SDK for credential handling — tokens never stored.

Official Microsoft MCP server enabling AI to interact with Power BI semantic models: create/modify tables, columns, measures, relationships, security roles, DAX queries, and calculation groups.

Create new calculated metrics in your Power BI reports using plain English
Add tables and relationships to your data model without opening Power BI
Set up role-based access so each team sees only their own data

979 starsMIT (commercial OK)FreeNo code needed

Why it matters

Enables AI-assisted BI development in Power BI and Microsoft Fabric. Azure Identity SDK for credential handling — tokens never stored. Note: backup models before AI operations.

Best for

Clients with large Power BI investments who want AI to accelerate semantic model development, DAX measure creation, and security role management.

Works in

Claude Code Claude Cowork Claude Chat

Source

https://github.com/microsoft/powerbi-modeling-mcp

By Microsoft

How to Get It

Option 1: Claude Desktop AppOpen the Customize panel in the sidebar → browse connectors → search and add. Works in Claude Code, Claude Cowork, and Claude Chat.

Option 2: Paste into Claude CodeCopy the command below and paste it into a Claude Code conversation. Claude will run it for you.

Command

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

Tip: Paste this into a Claude Code conversation. Verify command matches your Claude Code version.

First thing to try

Once it’s connected, paste this into Claude:

Help me create new calculated metrics in my Power BI reports using plain English

PrerequisitesNode.js (for the npx install path); a Power BI Desktop model or Fabric semantic model to connect to. Recommended path is the Power BI Modeling MCP VS Code extension with GitHub Copilot.CostFree

Trust Signals Auto-scanned

Stars979Contributors4Last updated2026-07-10LicenseMIT (OK for commercial use)Known CVEsNone foundSources: GitHub Advisory Database + OSV.dev · Scanned 2026-07-21 · scanner v1

Data & Access

Data processingPrompts sent to Anthropic API. Enterprise/Team plans exclude training.Connects toMicrosoft servers (official integration)

Community Pulse Active

Discussed on Reddit

So turns out AI might be coming for the Power Bi developer jobs … — Reddit · 214 pts
The Official Power BI Modeling MCP Server is LIVE! — Reddit · 153 pts
Power BI November 2025 Feature Summary — Reddit · 85 pts

3 mentions across 1 sources

Reviewer notes

Auto-scanned review. These are observations, not a security certification.

catalog_hygiene stale-eval refresh: Scored from trust signals (evidence-eval-v1): 928 GitHub stars; 4 contributors; last commit 7d ago; license MIT.

Things to check

Public Preview — implementation may change significantly before GA. Microsoft warns to always back up your model before AI operations, and that LLMs may expose model data or metadata in logs and responses. Modeling operations only — it cannot edit report pages or diagram layouts.

How to evaluate tools before deploying →

Data shown here comes from public APIs and automated scanning. Reviewer notes reflect one person's experience. This is not a security certification or legal recommendation. Always evaluate tools according to your own organization's policies.

Evaluation Scores

Evaluation

Ease of Use

4/5

Versatility

4/5

Reliability

4/5

Security

4/5

Overall score4.00 / 5.00 SolidEvaluatedJul 2026

catalog_hygiene stale-eval refresh: Scored from trust signals (evidence-eval-v1): 928 GitHub stars; 4 contributors; last commit 7d ago; license MIT.

← Back to the Claude Observatory