Power BI Admin

A Python MCP server providing 43 tools for full Power BI administration via the Power BI REST API.

Features

• 43 MCP tools covering workspaces, reports, datasets, dashboards, dataflows, pipelines, capacities, gateways, and admin
• Dual auth: Service Principal (automation) or Delegated User (interactive via device code)
• Dual transport: stdio (local) or SSE (remote/Docker)
• Push datasets: Pipe data into Power BI programmatically
• DAX queries: Run queries against datasets
• Secure: Azure Key Vault support, no secrets in logs, restricted file permissions

Quick Start

Prerequisites

• Python 3.11+
• Azure AD app registration with Power BI API permissions

Local Setup

git clone <repo-url>
cd PowerBIMCP
python -m venv .venv
source .venv/bin/activate
pip install -e ".[dev]"
cp .env.example .env
# Edit .env with your Azure credentials

Run Locally (stdio)

powerbi-mcp

Claude Desktop Configuration

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "powerbi": {
      "command": "powerbi-mcp",
      "env": {
        "AZURE_TENANT_ID": "your-tenant-id",
        "AZURE_CLIENT_ID": "your-client-id",
        "AZURE_CLIENT_SECRET": "your-client-secret"
      }
    }
  }
}

Docker (SSE)

cp .env.example .env
# Edit .env with your Azure credentials
docker compose up -d

Configuration

Variable	Required	Default	Description
AUTH_METHOD	No	service_principal	service_principal, delegated, or auto
AZURE_TENANT_ID	Yes	—	Azure AD tenant ID
AZURE_CLIENT_ID	Yes	—	App registration client ID
AZURE_CLIENT_SECRET	For SP	—	Client secret
AZURE_KEYVAULT_URL	No	—	Key Vault URL for production
POWERBI_DEFAULT_WORKSPACE_ID	No	—	Default workspace
TRANSPORT	No	stdio	stdio or sse
SSE_PORT	No	8080	SSE port
DAX_QUERIES_ENABLED	No	true	Enable/disable DAX queries
LOG_LEVEL	No	INFO	Logging level

Development

pip install -e ".[dev]"
pytest tests/ -v