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.

Developer tools Research and data #PowerBI Analysis #MCP Service #Data Model .Python

rating : 2 points

downloads : 10

update time : 2025-04-28

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 AnalysisParse the data model structure in Power BI reports and identify entity relationship diagrams.

Column Relationship AnalysisAutomatically discover and record the associations between columns.

DAX Measure ParsingDecompose 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 ModeWhen you get a new Power BI report, you can start exploring with the following questions:

Document Generation ModeQuickly 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

🚀 PBIXRay MCP Server

A Model Context Protocol (MCP) server designed for PBIXRay. This server enables interaction with PBIX files via the MCP protocol.

✨ Features

Supported File Format: .pbix
Core Functions:
- Load and parse PBIX files
- Retrieve worksheet information
- Fetch dataset details
- Access field attributes
- Obtain DAX expressions (calculated columns, measures)
- Handle data slicing
- Download data in CSV or Excel format

📦 Installation

Install via pip

pip install pbixray-mcp-server

Install in Development Mode

Clone the repository:

git clone https://github.com/username/pbixray-mcp.git
cd pbixray-mcp

Install in development mode:
```
pip install -e .
```

Install dependencies (if installing from source code):

python -m venv venv
source venv/bin/activate  # On Windows, use: venv\Scripts\activate
pip install mcp pbixray numpy

🚀 Quick Start

Example Script

from pbixray_mcp_server import PbixMcpServer

# Initialize the MCP server
server = PbixMcpServer()

# Load and parse the PBIX file
with open("demo/AdventureWorks Sales.pbix", "rb") as file:
    server.load_file(file=file)

# Get available worksheets
print(server.worksheets())

# Get dataset information
print(server.dataset_info())

# Download data in CSV format
data = server.download_dataset()
data.to_csv("output.csv")

Interactive Testing with MCP Checker

# Start the MCP checker
mcp dev src/pbixray_server.py

This will initiate an interactive session where you can call tools and test responses.

📚 Documentation

Project Structure

pbixray-mcp/
├── README.md            - This file
├── INSTALLATION.md      - Detailed installation instructions
├── src/                 - Source code
│   ├── __init__.py
│   └── pbixray_server.py
├── tests/               - Test scripts
│   ├── __init__.py
│   ├── conftest.py
│   ├── test_server.py
│   └── test_with_sample.py
├── examples/            - Example scripts and configurations
│   ├── demo.py
│   └── config/
├── demo/                - Sample PBIX files
│   ├── README.md
│   └── AdventureWorks Sales.pbix
└── docs/                - Additional documentation
    └── ROADMAP.md