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	✅	✅