How do I use powerbi-mcp?

1. Click on "Deploy Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@powerbi-mcp Analyze the Sales.pbix file for metrics and measures" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

powerbi-mcp

by AjvoGod

Overview Schema Source Related Servers Discussions Admin

TypeScript

Hybrid

Power BI MCP Server

License: MIT Node.js

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.

Related MCP server: pbix-mcp

📋 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:

Node.js 20+ installed
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	✅	✅

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive

ResponsivenessNo issues

Resources

Need Help?

Related Servers

Related MCP Connectors

LemonadoOAuth
io.github.lemonadolabs
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
Marketing Research & Data Databases
3
SelineOAuth
io.github.getseline
MCP server for the Seline Analytics API
Product Management Data Visualization
12
PDF Redaction MCP AOAuth
com.pdf-redaction
MCP server for detecting and redacting PII (Personally Identifiable Information) in PDF documents.
File Systems Security
23
Bitrix MCP A
io.github.bitrix24
MCP server that delivers up-to-date Bitrix24 REST API documentation.
Documentation Access API Testing Developer Tools
53

Related MCP Servers

powerbi-mcp-local
Data Visualization Developer Tools Databases
inerthel-agi
A
license
C
quality
A
maintenance
Local-first MCP server for Power BI Desktop automation. Automate semantic model changes, DAX, Power Query, Excel, and report layout from MCP-capable AI clients.
Updated 3 days ago (2026-09-23 18:41 UTC)
100
1
MIT
pbix-mcp
Data Visualization Databases Developer Tools
d0nk3yhm
A
license
Not graded
quality
A
maintenance
MCP server for creating, editing, and evaluating Power BI (.pbix/.pbit) files without Power BI Desktop. Supports 101 tools including report creation, data sources, DAX measures, and file manipulation.
Updated a month ago (2026-08-31 23:36 UTC)
683 PyPI
20
MIT
fabric-model-reader-mcp
Cloud Platforms Databases
data-goblin
F
license
Not graded
quality
D
maintenance
MCP server for reading and analyzing Fabric semantic models. Supports getting model definitions and executing DAX queries against Power BI datasets.
Updated a year ago (2025-08-12 11:38 UTC)
17
-
powerbi-plus
Developer Tools Data Visualization
rajivdatta
A
license
Not graded
quality
D
maintenance
MCP server for building and inspecting Power BI report visuals by editing PBIR files on disk, enabling page, chart, slicer, and layout management.
Updated 3 months ago (2026-06-23 03:02 UTC)
MIT