Power BI
The MCP server connects Claude AI to Power BI Desktop, enabling AI-driven querying and analysis of Power BI models. It lets users explore data, run DAX queries, and retrieve metadata seamlessly within Claude. The integration runs locally on Windows,
What is Power BI?
Power BI is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp server connects claude ai to power bi desktop, enabling ai-driven querying and analysis of power bi models. it lets users explore data, run dax queries, and retrieve metadata seamlessly within cla...
The MCP server connects Claude AI to Power BI Desktop, enabling AI-driven querying and analysis of Power BI models. It lets users explore data, run DAX queries, and retrieve metadata seamlessly within Claude. The integration runs locally on Windows,
This server falls under the Analytics category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- The MCP server connects Claude AI to Power BI Desktop, enabl
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx power-bi-custom-mcp-server-with-python-claude-ai-integrationConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Power BI
The Power BI Custom MCP Server connects Claude AI to Power BI Desktop running locally on Windows, enabling AI-driven querying and analysis of live Power BI data models. It uses Python with the pythonnet library to communicate with Analysis Services via Windows Integrated Security (SSPI), requiring no API keys or external credentials. Through eight exposed tools, Claude can retrieve active models, list tables and columns, execute DAX queries, inspect measures and relationships, and access report pages — making it possible to explore and analyze Power BI data entirely through natural language.
Prerequisites
- Windows OS (the integration uses Windows Integrated Security and pythonnet, which require Windows)
- Power BI Desktop installed and running with at least one report open
- Python 3.8 or higher installed on Windows
- pip package manager available
- Claude Desktop for Windows installed
Clone the repository
Clone the Power BI MCP Server repository to your Windows machine.
git clone https://github.com/DheerajKumar97/Power-BI-Custom-MCP-Server-with-Python--Claude-AI-Integration.git
cd Power-BI-Custom-MCP-Server-with-Python--Claude-AI-IntegrationCreate a Python virtual environment
Create and activate a virtual environment to keep the dependencies isolated from your system Python installation.
python -m venv venv
venv\Scripts\activateInstall required Python packages
Install the mcp and pythonnet packages. pythonnet provides the .NET bridge needed to connect to the Analysis Services instance used by Power BI Desktop.
pip install mcp pythonnetNote the full path to your Python executable and the server script
You need the absolute paths to both the Python executable inside your virtual environment and the powerbi_mcp_server.py script for the Claude Desktop config.
# Run from inside the activated venv
where python
# Example output: C:\Users\YourName\...\venv\Scripts\python.exe
# Full path to the server script
dir powerbi_mcp_server.pyOpen Power BI Desktop with a report
Before configuring Claude Desktop, open Power BI Desktop and load the report you want to analyze. The MCP server connects to the running Power BI Desktop Analysis Services instance, so Power BI must be active when you use the integration.
Configure Claude Desktop
Edit the Claude Desktop config file at %APPDATA%\Claude\claude_desktop_config.json. Add the powerbi MCP server entry using the paths from step 4.
Restart Claude Desktop and connect
Quit and reopen Claude Desktop while Power BI Desktop is running. Ask Claude to list the available Power BI models to verify the connection.
Power BI Examples
Client configuration
Claude Desktop configuration for Windows. Replace the Python executable path and server script path with your actual absolute paths.
{
"mcpServers": {
"powerbi": {
"command": "C:\\Users\\YourName\\PowerBI-MCP\\venv\\Scripts\\python.exe",
"args": ["C:\\Users\\YourName\\PowerBI-MCP\\powerbi_mcp_server.py"]
}
}
}Prompts to try
These queries use the eight tools exposed by the server: get_powerbi_models, get_model_tables, get_table_columns, execute_dax_query, get_measures, get_relationships, get_report_pages, and get_page_visuals.
- "Show me all tables in my currently open Power BI model."
- "What columns are in the Sales table and what are their data types?"
- "Execute this DAX query and show me the results: EVALUATE TOPN(10, Sales, Sales[Revenue], DESC)"
- "List all the measures defined in this model and their DAX expressions."
- "Show me the relationships between tables in this Power BI model."Troubleshooting Power BI
pythonnet fails to install or import with 'clr' module not found
Ensure you are using Python 3.8-3.11 (pythonnet has limited support for newer Python versions on Windows). Run 'pip install pythonnet==3.0.3' to pin a known-working version. Also make sure you have the .NET Framework 4.7+ installed on Windows, which is typically present by default on Windows 10 and 11.
Server cannot find an active Power BI model
Power BI Desktop must be running and have a report open before you query the MCP server. The server connects to the local Analysis Services port that Power BI starts dynamically. If you have multiple reports open, close all but one and retry. You may need to restart Power BI Desktop if the port connection was lost.
DAX queries return errors or unexpected results
Verify your DAX syntax is valid by testing the query directly in Power BI Desktop's DAX Query View (Tools → DAX Query View). The MCP server passes your DAX directly to Analysis Services — any syntax error in the DAX will surface as an error from the tool. Start with simple queries like EVALUATE VALUES(TableName[ColumnName]) to confirm connectivity.
Frequently Asked Questions about Power BI
What is Power BI?
Power BI is a Model Context Protocol (MCP) server that mcp server connects claude ai to power bi desktop, enabling ai-driven querying and analysis of power bi models. it lets users explore data, run dax queries, and retrieve metadata seamlessly within claude. the integration runs locally on windows, It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Power BI?
Follow the installation instructions on the Power BI GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Power BI?
Power BI works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Power BI free to use?
Yes, Power BI is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Power BI Alternatives — Similar Analytics Servers
Looking for alternatives to Power BI? Here are other popular analytics servers you can use with Claude, Cursor, and VS Code.
OpenMetadata
★ 14.0kOpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
Superset
★ 10.9kAn MCP server that provides AI assistants with full access to Apache Superset instances, enabling interaction with dashboards, charts, datasets, databases, and SQL execution capabilities.
Horizon
★ 4.4k📡 Your own AI-powered news radar. Generates daily briefings in English & Chinese. | 用 AI 构建你专属的新闻雷达
MCP Server Chart
★ 4.1kEnables generation of 25+ types of charts and data visualizations using AntV, including bar charts, line charts, maps, mind maps, and specialized diagrams like fishbone and sankey charts. Supports both statistical charts and geographic visualizations
Muapi CLI
★ 997Official CLI for muapi.ai — generate images, videos & audio from the terminal. MCP server, 14 AI models, npm + pip installable.
Weather MCP Server
★ 907Weather Data Fetcher MCP server built with Node.js, MCP SDK, and Zod. Provides weather details like temperature and forecast for cities such as Noida and Delhi via a registered tool. Simplifies API integration, enabling structured responses for clien
Browse More Analytics MCP Servers
Explore all analytics servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Power BI in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Power BI?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.