Jonaolden Pbixray MCP Server
J

Jonaolden Pbixray MCP Server

The PBIXRay MCP Server is a Model Context Protocol (MCP) service provided for the Power BI file analysis tool PBIXRay. It exposes the functions of PBIXRay as tools and resources through the MCP protocol for LLM clients to interact with Power BI (.pbix) files. This service supports functions such as loading and analyzing PBIX files, exploring data models, accessing through query languages, and analyzing data structures, and available tools can be selected through configuration.
2 points
7.3K

Basic Concepts

Power BI is Microsoft's data visualization and business intelligence tool that helps users create and share data dashboards, reports, and datasets.

Features

The PBIXRay MCP server provides the following core features: 1. Data model analysis 2. Exploration of table and column relationships 3. Parsing of DAX measure formulas 4. Viewing of M - format data processing code

Application Scenarios

Suitable for the following scenarios: 1. Analysis of new report structures 2. Generation of report hand - over documents 3. Root cause troubleshooting of data issues 4. Providing performance optimization suggestions
Data Model Analysis
Parse the data model structure in Power BI reports and identify entity relationship diagrams.
Column Relationship Analysis
Automatically discover and record the associations between columns.
DAX Measure Parsing
Decompose and explain complex DAX measure formulas, providing clear instructions on calculation steps.
Installation and Preparation
Ensure that the WSL environment is correctly installed and the PBIXRay library is cloned.
Start the Server
Run the start command in the terminal to start the MCP service.
Newcomer Exploration Mode
When you get a new Power BI report, you can start exploring with the following questions:
Document Generation Mode
Quickly generate technical documents for reports to facilitate team collaboration.
How to handle large - scale datasets?
Does it support real - time data analysis?
Official Documentation
Technical Blog

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.

Alternatives

C
Claude Context
Claude Context is an MCP plugin that provides in - depth context of the entire codebase for AI programming assistants through semantic code search. It supports multiple embedding models and vector databases to achieve efficient code retrieval.
TypeScript
9.6K
5 points
M
Maverick MCP
Python
7.7K
4 points
A
Acemcp
Acemcp is an MCP server for codebase indexing and semantic search, supporting automatic incremental indexing, multi-encoding file processing, .gitignore integration, and a Web management interface, helping developers quickly search for and understand code context.
Python
12.0K
5 points
B
Blueprint MCP
Blueprint MCP is a chart generation tool based on the Arcade ecosystem. It uses technologies such as Nano Banana Pro to automatically generate visual charts such as architecture diagrams and flowcharts by analyzing codebases and system architectures, helping developers understand complex systems.
Python
8.1K
4 points
M
MCP Agent Mail
MCP Agent Mail is a mail - based coordination layer designed for AI programming agents, providing identity management, message sending and receiving, file reservation, and search functions, supporting asynchronous collaboration and conflict avoidance among multiple agents.
Python
10.5K
5 points
K
Klavis
Klavis AI is an open-source project that provides a simple and easy-to-use MCP (Model Context Protocol) service on Slack, Discord, and Web platforms. It includes various functions such as report generation, YouTube tools, and document conversion, supporting non-technical users and developers to use AI workflows.
TypeScript
15.4K
5 points
M
MCP
The Microsoft official MCP server provides search and access functions for the latest Microsoft technical documentation for AI assistants
12.7K
5 points
A
Aderyn
Aderyn is an open - source Solidity smart contract static analysis tool written in Rust, which helps developers and security researchers discover vulnerabilities in Solidity code. It supports Foundry and Hardhat projects, can generate reports in multiple formats, and provides a VSCode extension.
Rust
10.2K
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
18.3K
4.5 points
D
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
57.5K
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
29.0K
5 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
18.7K
4.3 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
52.6K
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#
24.3K
5 points
G
Gmail MCP Server
A Gmail automatic authentication MCP server designed for Claude Desktop, supporting Gmail management through natural language interaction, including complete functions such as sending emails, label management, and batch operations.
TypeScript
19.3K
4.5 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
38.9K
4.8 points
AIBase
Zhiqi Future, Your AI Solution Think Tank
© 2025AIBase