Power BI Analyst MCP
Connect your agent to Power BI workspaces so it can list assets, run DAX, and page through large result sets while you build reports or data products.
Overview
io.github.mbrummerstedt/powerbi-analyst-mcp is an MCP server for the Grow phase that lets agents browse Power BI workspaces, run DAX queries, and page through large results.
What is this MCP server?
- Browse Power BI workspaces from the agent via MCP
- Execute DAX queries and retrieve tabular results
- Pagination for large query result sets
- Azure AD auth via POWERBI_CLIENT_ID and POWERBI_TENANT_ID env vars
- PyPI powerbi-analyst-mcp v0.1.1 stdio transport
- Server version 0.1.1 on PyPI identifier powerbi-analyst-mcp
- Two documented environment variables: POWERBI_CLIENT_ID, POWERBI_TENANT_ID
- Stdio transport per MCP server schema
What problem does it solve?
Ad hoc Power BI questions trap solo builders in the web UI and manual DAX copy-paste instead of agent-driven exploration.
Who is it for?
Indie SaaS operators or consultants with existing Power BI tenants who want MCP-native BI assistance in Claude Code or Cursor.
Skip if: Builders without Power BI licensing, Azure app registration, or those who need full report authoring inside the agent.
What do I get? / Deliverables
Once configured with Azure AD IDs, your agent can query workspaces and DAX with paginated results you can use in specs, support, or product decisions.
- Workspace and artifact listings usable in agent context
- DAX query result sets with pagination support
- Repeatable BI Q&A workflows inside coding sessions
Recommended MCP Servers
Journey fit
Power BI querying supports the grow phase when builders iterate on metrics, customer dashboards, and operational reporting tied to shipped products. Analytics subphase matches DAX exploration and workspace browsing—core BI measurement work rather than initial coding of UI components.
How it compares
MCP analyst bridge to Power BI APIs, not a replacement for Power BI Desktop or Fabric pipelines.
Common Questions / FAQ
Who is io.github.mbrummerstedt/powerbi-analyst-mcp for?
Solo builders and small teams using Power BI who want their AI agent to browse workspaces and run DAX through MCP.
When should I use io.github.mbrummerstedt/powerbi-analyst-mcp?
Use it in grow analytics when you need repeatable DAX runs and paged results while iterating metrics, support answers, or internal dashboards.
How do I add io.github.mbrummerstedt/powerbi-analyst-mcp to my agent?
Install powerbi-analyst-mcp from PyPI, set POWERBI_CLIENT_ID and POWERBI_TENANT_ID, add the stdio MCP server entry, and authenticate per your Azure AD app setup.