Skip to main content
Glama
AjvoGod

powerbi-mcp

by AjvoGod
OverviewSchemaRelated ServersScoreDiscussions
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.

📋 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

✅

✅

This server cannot be installed

A
license - permissive license
-
quality - not tested
C
maintenance

How are these scores calculated?

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/AjvoGod/powerbi-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server