MCP server for natural language interaction with Power BI datasets
Config is the same across clients — only the file and path differ.
{
"mcpServers": {
"powerbi": {
"env": {
"PYTHONPATH": "C:/path/to/powerbi-mcp-v2/src"
},
"args": [
"C:/path/to/powerbi-mcp-v2/src/server.py"
],
"command": "python"
}
}
}Are you the author?
Add this badge to your README to show your security score and help users find safe servers.
Disclaimer: This is an independent, community-developed tool and is not affiliated with, endorsed by, or connected to Microsoft Corporation or Anthropic.
No automated test available for this server. Check the GitHub README for setup instructions.
Five weighted categories — click any category to see the underlying evidence.
No known CVEs.
No package registry to scan.
Click any tool to inspect its schema.
Be the first to review
Have you used this server?
Share your experience — it helps other developers decide.
Sign in to write a review.
Others in analytics / data
Manage Supabase projects — databases, auth, storage, and edge functions
MCP Server for GCP environment for interacting with various Observability APIs.
🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
The Apify MCP server enables your AI agents to extract data from social media, search engines, maps, e-commerce sites, or any other website using thousands of ready-made scrapers, crawlers, and automation tools available on the Apify Store.
MCP Security Weekly
Get CVE alerts and security updates for Powerbi Mcp and similar servers.
Start a conversation
Ask a question, share a tip, or report an issue.
Sign in to join the discussion.
An enterprise-grade Model Context Protocol server for Power BI
Enable AI assistants to interact with Power BI Desktop and Power BI Service through natural language.
Disclaimer: This is an independent, community-developed tool and is not affiliated with, endorsed by, or connected to Microsoft Corporation or Anthropic.
Power BI MCP Server bridges the gap between AI assistants and Microsoft Power BI, enabling seamless interaction with semantic models through the Model Context Protocol. Whether you're working with local .pbix files or cloud-hosted datasets, this server provides a unified interface for querying data, managing models, and performing bulk operations—all while maintaining enterprise-grade security.
| Capability | Description |
|---|---|
| Dual Connectivity | Connect to both Power BI Desktop (local) and Power BI Service (cloud) |
| Natural Language Queries | Execute DAX queries through conversational AI |
| Bulk Operations | Rename tables, columns, and measures across your model |
| Security First | PII detection, audit logging, and configurable access policies |
| RLS Testing | Test Row-Level Security roles during development |
| Safe Refactoring | PBIP-based editing preserves report visual integrity |
In V1, we successfully connected to Power BI Service via XMLA endpoints. V2 introduced Power BI Desktop connectivity and write operations using Microsoft's Tabular Object Model (TOM). However, we encountered a critical limitation:
Problem: Renaming a table via TOM breaks all report visuals referencing that table.
Root Cause Analysis:
Power BI stores data in two separate layers:
+------------------------+ +------------------------+
| Semantic Model | | Report Definition |
| (Model Layer) | | (Report Layer) |
+------------------------+ +------------------------+
| - Tables | | - Visual bindings |
| - Columns | | - Slicers & filters |
| - Measures | | - Bookmarks |
| - Relationships | | - Field references |
| - DAX expressions | | - Formatting |
+------------------------+ +------------------------+
| |
v v
TOM can modify TOM CANNOT modify
When you rename a table using TOM, it updates:
But it cannot update:
report.jsonThis causes visuals to show errors like "Can't find column 'OldTableName'[Column]".
We researched Microsoft's own approach and discovered that even their tools face this limitation. The solution lies in the Power BI Project (PBIP) format—a text-based representation of both the model and report.
Two Report Formats Supported:
| Format | Structure | Def