AI导哈

Power BI MCP 服务器

Power BI MCP 服务器是一个为 AI 助手和开发工具提供 Power BI 数据访问与自动化能力的 MCP 服务，支持本地 PBIX 文件分析、云 API 操作、报表导出和语义模型提取，适用于 Power BI 数据管理与报表自动化场景。

  • by AjvoGod
  • TypeScript
  • 本地部署
  • 1 星标
  • 更新于
在 GitHub 查看 AjvoGod/powerbi-mcp

使用说明

Power BI MCP Server

MCP server for Power BI — local PBIX file analysis, cloud API operations, report export, and semantic model extraction from Power BI Desktop.

45 tools • TypeScript • Cross-platform • Optimized for Pro license

⚡ Quick Start

No cloning, no building. Just add to your MCP client config:

{
  "mcpServers": {
    "powerbi": {
      "command": "npx",
      "args": ["-y", "github:AjvoGod/powerbi-mcp"],
      "env": {
        "POWERBI_PBIX_ROOT": "/path/to/your/pbix/files"
      }
    }
  }
}

PBIX local analysis works immediately — no Azure credentials needed. For cloud operations (workspaces, refresh, export) add AZURE_TENANT_ID, AZURE_CLIENT_ID, AZURE_CLIENT_SECRET to env.

📋 Client Configuration

Claude Desktop

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "powerbi": {
      "command": "npx",
      "args": ["-y", "github:AjvoGod/powerbi-mcp"],
      "env": {
        "POWERBI_PBIX_ROOT": "/path/to/pbix"
      }
    }
  }
}

Gemini CLI (Google)

~/.gemini/settings.json:

{
  "mcpServers": {
    "powerbi": {
      "command": "npx",
      "args": ["-y", "github:AjvoGod/powerbi-mcp"],
      "env": {
        "POWERBI_PBIX_ROOT": "/path/to/pbix"
      }
    }
  }
}

Codex CLI (OpenAI)

~/.codex/config.json:

{
  "mcpServers": {
    "powerbi": {
      "command": "npx",
      "args": ["-y", "github:AjvoGod/powerbi-mcp"],
      "env": {
        "POWERBI_PBIX_ROOT": "/path/to/pbix"
      }
    }
  }
}

VS Code / Codex IDE / GitHub Copilot

Add to your project's .vscode/mcp.json or user settings:

{
  "servers": {
    "powerbi": {
      "command": "npx",
      "args": ["-y", "github:AjvoGod/powerbi-mcp"],
      "env": {
        "POWERBI_PBIX_ROOT": "${workspaceFolder}"
      }
    }
  }
}

Tip: VS Code extensions like Codex IDE, Cline, Roo Code, and GitHub Copilot all support MCP servers through this same .vscode/mcp.json configuration.

Cursor

Settings → MCP Servers → Add:

{
  "mcpServers": {
    "powerbi": {
      "command": "npx",
      "args": ["-y", "github:AjvoGod/powerbi-mcp"],
      "env": {
        "POWERBI_PBIX_ROOT": "/path/to/pbix"
      }
    }
  }
}

Windsurf

Settings → MCP → Add Server:

{
  "mcpServers": {
    "powerbi": {
      "command": "npx",
      "args": ["-y", "github:AjvoGod/powerbi-mcp"],
      "env": {
        "POWERBI_PBIX_ROOT": "/path/to/pbix"
      }
    }
  }
}

🔑 Access Requirements

This server is installed directly from public GitHub. Users only need:

  1. Node.js 20+ installed
  2. Git installed

No GitHub account or authentication is required!

🔧 Environment Variables

Variable Required Description
POWERBI_PBIX_ROOT No Root folder containing .pbix files
AZURE_TENANT_ID For cloud Azure AD tenant ID
AZURE_CLIENT_ID For cloud Azure AD app client ID
AZURE_CLIENT_SECRET For cloud Azure AD app secret
LOG_LEVEL No Logging level: debug, info, warn, error

With cloud credentials (optional):

{
  "env": {
    "POWERBI_PBIX_ROOT": "/path/to/pbix",
    "AZURE_TENANT_ID": "xxxx",
    "AZURE_CLIENT_ID": "xxxx",
    "AZURE_CLIENT_SECRET": "xxxx"
  }
}

🛠 Tools (45)

Category Count Description
📁 PBIX Local 11 Analysis, M code, layout, metadata, datasources, comparison, batch, documentation, desktop discovery, semantic model, server info
📊 Dataset 9 List, detail, tables, sources, parameters, refresh
📄 Report 9 List, detail, pages, export PDF/PNG/PPTX, clone, rebind, export & download
🏢 Workspace 3 List, detail, users
🔄 Dataflow 4 List, detail, sources, refresh
🔐 Admin 3 Activity log, workspace scan, apps
📋 Dashboard 2 List, tiles
🌐 Gateway 2 List, datasources
⚡ Capacity 2 List, workloads

💬 Usage Examples

Without Azure credentials (PBIX analysis)

"Analyze the PBIX file Finance/Invoice Report.pbix"
"Show me the Power Query (M) code from this PBIX"
"Generate markdown documentation from all PBIX files in a folder"
"Compare these two PBIX files"
"Describe the report for intranet (Business description, Technical description, Filters, Measures sections; no tables)"
"Find running local models from Power BI Desktop"
"Extract tables and measures from the open Desktop report"

With Azure credentials (Cloud operations)

"List all workspaces"
"Trigger a refresh for dataset Y"
"Export report Z to PDF and download it"
"Show the refresh history for a dataset"

⚠️ Limitations (Pro license)

Feature Pro Premium/PPU
REST API (list, refresh, export) ✅ ✅
XMLA endpoint (DAX queries) ❌ ✅
Enhanced refresh ❌ ✅
Refresh limit 8/day Per capacity
PBIX local analysis ✅ ✅

Author

Ivo Schwarz — Software, Data & AI Engineer.

相关 MCP