mbrummerstedt/powerbi-analyst-mcp

Overview

Connects your AI assistant to Power BI so you can ask about the numbers in a dataset without opening a report or building a new visual. A useful shortcut for a business that already runs its dashboards in Power BI and wants a faster way to get an answer to an ad hoc question. Runs locally, so setup is a bit more hands-on than a hosted connector.

Best for

Best for
Businesses running dashboards in Power BI who want quick answers to ad hoc questions

Use cases

• Ask an ad hoc question about a Power BI dataset without building a new report
• Pull a quick number for a meeting from an existing dataset
• Explore data through natural-language questions instead of DAX
• Get a faster answer than waiting on a new dashboard build

How to use

Install

pip install powerbi-analyst-mcp

Tools exposed

• list_apps
• list_datasets
• get_dataset_info
• list_tables
• list_measures
• list_columns
• execute_dax
• read_query_result
• search_query_history
• delete_query_log_entry
• query_summary
• result_name
• max_rows

Tested with

Claude Desktop, Cursor

Example client config

{\n  "mcpServers": {\n    "powerbi": {\n      "command": "uvx",\n      "args": ["powerbi-analyst-mcp"],\n      "env": {\n        "POWERBI_CLIENT_ID": "your-application-client-id",\n        "POWERBI_TENANT_ID": "your-directory-tenant-id"\n      }\n    }\n  }\n}

Notes

A local MCP server that connects Power BI to an LLM for analysis. It runs as a Python-based server, enabling natural language queries against Power BI datasets.

9 stars on GitHub. Last updated 2026-04-15. Licensed MIT.

Use cases

• Query Power BI data using natural language through an LLM
• Automate ad-hoc analysis by bridging Power BI with AI models
• Integrate Power BI into custom MCP-compatible workflows

Pros

• Enables natural language interaction with Power BI data
• Lightweight Python implementation easy to set up locally
• Open source with a clear, focused purpose

Cons

• Very small community (9 stars) with limited support
• Requires local server setup and MCP compatibility
• Narrow scope: only connects Power BI to LLMs for analysis

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.