Skip to content
MCP server

PowerBI MCP Server

PowerBI REST API integration. Query workspaces, datasets, and execute DAX queries via MCP.

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
0.1.2
Listing updated
5 days ago

About PowerBI MCP Server

PowerBI MCP Server is an open-source MCP server. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

claude mcp add powerbi-mcp --env POWERBI_TENANT_ID='<POWERBI_TENANT_ID>' --env POWERBI_CLIENT_ID='<POWERBI_CLIENT_ID>' --env POWERBI_CLIENT_SECRET='<POWERBI_CLIENT_SECRET>' -- uvx powerbi-mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "powerbi-mcp": {
      "command": "uvx",
      "args": [
        "powerbi-mcp"
      ],
      "env": {
        "POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
        "POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
        "POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "powerbi-mcp": {
      "command": "uvx",
      "args": [
        "powerbi-mcp"
      ],
      "env": {
        "POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
        "POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
        "POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "powerbi-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "powerbi-mcp"
      ],
      "env": {
        "POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
        "POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
        "POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "powerbi-mcp": {
      "command": "uvx",
      "args": [
        "powerbi-mcp"
      ],
      "env": {
        "POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
        "POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
        "POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "powerbi-mcp": {
      "command": "uvx",
      "args": [
        "powerbi-mcp"
      ],
      "env": {
        "POWERBI_TENANT_ID": "<POWERBI_TENANT_ID>",
        "POWERBI_CLIENT_ID": "<POWERBI_CLIENT_ID>",
        "POWERBI_CLIENT_SECRET": "<POWERBI_CLIENT_SECRET>"
      }
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

Configuration

  • POWERBI_TENANT_IDAzure AD Tenant ID for PowerBI authenticationRequired
  • POWERBI_CLIENT_IDAzure AD Application (Client) ID with PowerBI API accessRequired
  • POWERBI_CLIENT_SECRETAzure AD Client Secret for service principal authenticationRequired

Pricing

Open source

PowerBI MCP Server FAQ

Is PowerBI MCP Server free?

Yes. PowerBI MCP Server is open source, so you can use and self-host it for free.

How do I add PowerBI MCP Server to Claude Code?

Run this command in your terminal: claude mcp add powerbi-mcp --env POWERBI_TENANT_ID='<POWERBI_TENANT_ID>' --env POWERBI_CLIENT_ID='<POWERBI_CLIENT_ID>' --env POWERBI_CLIENT_SECRET='<POWERBI_CLIENT_SECRET>' -- uvx powerbi-mcp

Where this comes from

  • Description: from the official MCP Registry entry.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers