PowerBI Analyzer
MCP server to give llms such as Claude, GitHub Copilot etc full PowerBI model context (from input .pbix) through tools based on PBIXRay python package.
What is PowerBI Analyzer?
PowerBI Analyzer is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to mcp server to give llms such as claude, github copilot etc full powerbi model context (from input .pbix) through tools based on pbixray python package.
MCP server to give llms such as Claude, GitHub Copilot etc full PowerBI model context (from input .pbix) through tools based on PBIXRay python package.
This server falls under the Analytics category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- MCP server to give llms such as Claude, GitHub Copilot etc f
Use Cases
Maintainer
Works with
Installation
NPM
npx -y pbixrayManual Installation
npx -y pbixrayConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use PowerBI Analyzer
The PBIXRay MCP server gives language models full structural visibility into Power BI report files (.pbix), bridging the gap between AI assistants and the complex DAX models, relationships, and M queries locked inside those files. By loading a .pbix file into the server, you can ask Claude or GitHub Copilot to explain DAX measures, enumerate table relationships, inspect Power Query transformations, and retrieve paginated table contents. It is built on the PBIXRay Python library and exposes 14 dedicated tools covering every layer of a Power BI data model.
Prerequisites
- Python 3.9 or later installed
- pip or pipx available for installing Python packages
- A .pbix Power BI report file you want to analyze
- Claude Desktop, GitHub Copilot, or another MCP-compatible client
Install the PBIXRay MCP server
Install the pbixray-mcp-server package from PyPI using pip.
pip install pbixray-mcp-serverLocate the installed entry point
After installation, confirm the executable path. You will need this path for the MCP client configuration.
which pbixray-mcp-server
# or on Windows: where pbixray-mcp-serverConfigure your MCP client
Add the server to your Claude Desktop or other MCP client configuration. You can optionally pass --max-rows and --page-size flags to control data output limits.
Load a .pbix file into the server
Use the load_pbix_file tool from within your AI client, providing the absolute path to the .pbix file you want to analyze.
Explore the data model
Once the file is loaded, use tools like get_tables, get_dax_measures, get_relationships, and get_schema to explore the model structure with your AI assistant.
PowerBI Analyzer Examples
Client configuration
Add this block to your claude_desktop_config.json to register the PBIXRay MCP server. Adjust the command path to match your Python environment.
{
"mcpServers": {
"pbixray": {
"command": "pbixray-mcp-server",
"args": ["--max-rows", "100", "--page-size", "20"]
}
}
}Prompts to try
Use these prompts in Claude Desktop after loading a .pbix file with the load_pbix_file tool.
- "Load the file at /Users/me/reports/SalesReport.pbix and give me an overview of the data model."
- "List all DAX measures in the Sales table and explain what each one calculates."
- "Show me the relationships between tables in this Power BI model."
- "Retrieve the Power Query M code for the Customer table."
- "Get the first 50 rows from the Orders table."Troubleshooting PowerBI Analyzer
pbixray-mcp-server command not found after installation
The pip scripts directory may not be on your PATH. Run pip show pbixray-mcp-server to find the install location, then add that directory to your PATH, or use the full absolute path in the MCP client configuration.
load_pbix_file returns an error about file format
Ensure the file is a valid .pbix file exported from Power BI Desktop. Files exported as .pbit (templates) are not directly supported. Also confirm the file path is absolute and the file is readable by the process running the MCP server.
DAX measures or table contents return truncated results
Use the --max-rows and --page-size arguments to increase data limits, or use the page parameter in get_table_contents to paginate through the data. For example: get_table_contents(table_name='Sales', page=2, page_size=50).
Frequently Asked Questions about PowerBI Analyzer
What is PowerBI Analyzer?
PowerBI Analyzer is a Model Context Protocol (MCP) server that mcp server to give llms such as claude, github copilot etc full powerbi model context (from input .pbix) through tools based on pbixray python package. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install PowerBI Analyzer?
Install via npm with the command: npx -y pbixray. Then add the server configuration to your AI client's JSON config file (e.g., claude_desktop_config.json or .cursor/mcp.json).
Which AI clients work with PowerBI Analyzer?
PowerBI Analyzer works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is PowerBI Analyzer free to use?
Yes, PowerBI Analyzer is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
PowerBI Analyzer Alternatives — Similar Analytics Servers
Looking for alternatives to PowerBI Analyzer? 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 PowerBI Analyzer 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 PowerBI Analyzer?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.