Power BI Analyst MCP for VS Code

io.github.mbrummerstedt/powerbi-analyst-mcp

Browse Power BI workspaces, run DAX queries, and page through large results.

client:VS Code transport:stdio runtime:pypi

Install Power BI Analyst MCP in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "powerbi-client-id",
      "description": "POWERBI_CLIENT_ID",
      "password": true
    },
    {
      "type": "promptString",
      "id": "powerbi-tenant-id",
      "description": "POWERBI_TENANT_ID",
      "password": true
    }
  ],
  "servers": {
    "powerbi-analyst-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "powerbi-analyst-mcp"
      ],
      "env": {
        "POWERBI_CLIENT_ID": "${input:powerbi-client-id}",
        "POWERBI_TENANT_ID": "${input:powerbi-tenant-id}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

Power BI Analyst MCP in other clients

Power BI Analyst MCP MCP server