AIbase
EN
Explore
Pbixray MCP Server
P

Pbixray MCP Server

PBIXRay MCP Server is a server based on the Model Context Protocol, providing analysis and interaction functions for Power BI (.pbix) files, including tools for data model exploration, query language access, and data structure analysis.
Developer toolsResearch and data#PowerBI Analysis#MCP Service#Data Model.Python
2.5 points
10

What is PBIXRay MCP Server?

PBIXRay MCP Server is a bridge that allows AI assistants to interact with Power BI files. It provides tools to explore data models, analyze structures, and access query languages (DAX/M) within .pbix files.

How to use PBIXRay MCP Server?

Simply configure the server in your AI client, then ask your assistant to analyze Power BI files. The server handles all the technical details while you get clear insights.

When should I use it?

Perfect for when you need to quickly understand Power BI files without opening Power BI Desktop, or when you want AI assistance with data model analysis.

Key Features

Data Model ExplorationDiscover tables, relationships and metadata in Power BI data models
Query Language AccessView Power Query (M) code and DAX expressions (measures, calculated columns)
Data Structure AnalysisExamine schemas, relationships and sample table contents
Configurable ToolsEnable/disable specific features based on your security needs

Pros and Cons

Advantages
No Power BI Desktop required for basic analysis
AI-friendly interface through natural language
Lightweight alternative to full Power BI installation
Configurable security through tool restrictions
Limitations
Requires WSL for Windows users (path conversion needed)
Doesn't support visualizations or report editing
Limited to analysis of existing .pbix files

Getting Started

Install the server
Install via pip or from source (see installation instructions)
Configure your AI client
Add server configuration to your AI client's settings file
Start analyzing
Ask your AI assistant to load and examine .pbix files

Example Scenarios

Exploring a new Power BI fileWhen you receive a new Power BI report and want to quickly understand its structure
Finding specific measuresWhen you need to locate and understand specific calculations in a complex model

Frequently Asked Questions

Why do I need to convert Windows paths to WSL paths?
Can I edit the Power BI file through this server?
How do I limit sensitive data exposure?

Additional Resources

PBIXRay GitHub
The core PBIXRay library powering this server
Model Context Protocol
Learn about the MCP standard this server implements
Power BI Documentation
Official Power BI resources from Microsoft
Installation
Copy the following command to your Client for configuration
{
  "mcpServers": {
    "pbixray": {
      "command": "wsl.exe",
      "args": [
        "bash",
        "-c",
        "source ~/dev/pbixray-mcp/venv/bin/activate && python ~/dev/pbixray-mcp/src/pbixray_server.py"
      ]
    }
  }
}

{
    "mcpServers": {
      "pbixray": {
        "command": "wsl.exe",
        "args": [
          "bash",
          "-c",
           "source ~/dev/pbixray-mcp/venv/bin/activate && python ~/dev/pbixray-mcp/src/pbixray_server.py --max-rows 100 --page-size 50 --disallow get_power_query"
         ],
         "env": {}
       }
     }
   }
Note: Your key is sensitive information, do not share it with anyone.
S
Search1api
The Search1API MCP Server is a server based on the Model Context Protocol (MCP), providing search and crawling functions, and supporting multiple search services and tools.
TypeScript
348
4 points
D
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
837
4.3 points
M
MCP Server Airbnb
Certified
MCP service for Airbnb listing search and details query
TypeScript
253
4 points
M
MCP Alchemy
Certified
MCP Alchemy is a tool that connects Claude Desktop to multiple databases, supporting SQL queries, database structure analysis, and data report generation.
Python
332
4.2 points
P
Postgresql MCP
A PostgreSQL database MCP service based on the FastMCP library, providing CRUD operations, schema inspection, and custom SQL query functions for specified tables.
Python
116
4 points
M
MCP Scan
MCP-Scan is a security scanning tool for MCP servers, used to detect common security vulnerabilities such as prompt injection, tool poisoning, and cross-domain escalation.
Python
624
5 points
A
Agentic Radar
Agentic Radar is a security scanning tool for analyzing and assessing agentic systems, helping developers, researchers, and security experts understand the workflows of agentic systems and identify potential vulnerabilities.
Python
562
5 points
C
Cloudflare
Changesets is a build tool for managing versions and releases in multi - package or single - package repositories.
TypeScript
1.5K
5 points
Featured MCP Services
D
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
837
4.3 points
G
Gitlab MCP Server
Certified
The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.
TypeScript
97
4.3 points
M
Markdownify MCP
Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.
TypeScript
1.7K
5 points
N
Notion Api MCP
Certified
A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.
Python
150
4.5 points
U
Unity
Certified
UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.
C#
572
5 points
F
Figma Context MCP
Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.
TypeScript
6.7K
4.5 points
C
Context7
Context7 MCP is a service that provides real-time, version-specific documentation and code examples for AI programming assistants. It is directly integrated into prompts through the Model Context Protocol to solve the problem of LLMs using outdated information.
TypeScript
5.2K
4.7 points
M
Minimax MCP Server
The MiniMax Model Context Protocol (MCP) is an official server that supports interaction with powerful text-to-speech, video/image generation APIs, and is suitable for various client tools such as Claude Desktop and Cursor.
Python
761
4.8 points
AIbase
Zhiqi Future, Your AI Solution Think Tank
English简体中文繁體中文にほんご
© 2025AIbase