Power BI Authoring MCP Server (Local)

Name: Power BI Authoring MCP Server (Local)
Author: microsoft

Verified · microsoft.com

MCP server by microsoft · updated 21 days ago · ★ 1.2k · 7.1k downloads a week

Score 94

The Power BI Authoring MCP server lets an AI agent create and change Power BI semantic models. Power BI Authoring MCP Server (Local) is published by microsoft.com from its verified domain in the official MCP Registry.

Install Add to Cursor Add to VS Code GitHub

Works withClaude Code Claude Desktop Cursor Codex Gemini CLI VS Code Windsurf Antigravity CLI

Maintenance

Last commit 21 days ago

Licence

MIT: permissive, fine for commercial use

Quality

Clear description, published package or server URL, 1,234 stars, original repository

Security

Not checked yet. What we check

Install Power BI Authoring MCP Server (Local)

Built from the published package, never by AI

claude mcp add power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcp

Run in your terminal. Add --scope user to use it in every project.

Step-by-step: install Power BI Authoring MCP Server (Local) in Claude Code

{
  "mcpServers": {
    "power-bi-authoring-mcp-server-local": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp"
      ]
    }
  }
}

Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.

Step-by-step: install Power BI Authoring MCP Server (Local) in Claude Desktop

{
  "mcpServers": {
    "power-bi-authoring-mcp-server-local": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp"
      ]
    }
  }
}

Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).

Step-by-step: install Power BI Authoring MCP Server (Local) in Cursor

{
  "servers": {
    "power-bi-authoring-mcp-server-local": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp"
      ]
    }
  }
}

Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".

Step-by-step: install Power BI Authoring MCP Server (Local) in VS Code

codex mcp add power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcp

Step-by-step: install Power BI Authoring MCP Server (Local) in Codex

{
  "mcpServers": {
    "power-bi-authoring-mcp-server-local": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/powerbi-modeling-mcp"
      ]
    }
  }
}

Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).

Step-by-step: install Power BI Authoring MCP Server (Local) in Antigravity CLI

gemini mcp add power-bi-authoring-mcp-server-local npx -y @microsoft/powerbi-modeling-mcp

Gemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.

Step-by-step: install Power BI Authoring MCP Server (Local) in Gemini CLI

MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the power-bi-authoring-mcp-server-local block.

Alternatives to Power BI Authoring MCP Server (Local)

All alternatives →

Agent-Native AnalyticsBuilderIO

Agent-Native Amplitude/Mixpanel - connect data sources, prompt for charts

AAA Remote 7.4k

Google Ads + Meta Ads + SEO/GEO MCPirinabuht12-oss

Google Ads, Meta Ads, Google Analytics (GA4) & Search Console MCP server by Ryze AI

AAA Remote 5.3k

Excel MCP Serverharis-musa

Create and edit Excel files with AI: charts, PivotTables, formulas. No Excel needed.

AAA Local 4.2k

MCP Gateway HarrisonCN

MCP gateway for AI models (OpenAI, Grok, DeepSeek, Claude and other function-calling LLMs) and for web pages and apps: one authenticated, observable endpoint in front of your MCP servers with routing, scopes, rate limits and metrics.

AAC Local 29k/wk

Deepnote MCP deepnote

MCP server for AI-assisted Deepnote notebook creation and manipulation

AAA Local 3.0k

SEO Skill iannuttall

Free Google Search Console MCP: your real GSC, Google Analytics and keyword data for AI agents.

AAA Local and remote 1.3k/wk

Power BI Authoring MCP Server (Local) vs Agent-Native Analytics Power BI Authoring MCP Server (Local) vs Google Ads + Meta Ads + SEO/GEO MCP Power BI Authoring MCP Server (Local) vs Excel MCP Server

Power BI Authoring MCP Server (Local): common questions

How do I install Power BI Authoring MCP Server (Local)?

In Claude Code run claude mcp add power-bi-authoring-mcp-server-local -- npx -y @microsoft/powerbi-modeling-mcp. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.

Is Power BI Authoring MCP Server (Local) the official server?

Power BI Authoring MCP Server (Local) is published by microsoft.com from its verified domain in the official MCP Registry.

Is Power BI Authoring MCP Server (Local) free?

The code is published under the MIT licence. The service it connects to may have its own pricing.

Is Power BI Authoring MCP Server (Local) safe to use?

It scores 94 of 100. Grades: maintenance A, licence A, quality A. The security check has not run for it yet. Review the code before you install. How grades work.

What are alternatives to Power BI Authoring MCP Server (Local)?

Does Power BI Authoring MCP Server (Local) work with ChatGPT?

Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.