Info!

those interested in this project might also be interested in this follow-up project, tabular-mcp, which allows running DAX queries against a local PowerBI model. support is highly appreciated !

PBIXRay MCP Server

A [Model Context Protocol][mcp] (MCP) server for PBIXRay.

This MCP server exposes the capabilities of PBIXRay as tools and resources for LLM clients to interact with Power BI (.pbix) files.

Features

• Loading and analyzing PBIX files
• Data model exploration
  • Listing tables in the model
  • Retrieving model metadata
  • Checking model size
  • Getting model statistics
  • Getting comprehensive model summary
• Query language access
  • Viewing Power Query (M) code
  • Accessing M Parameters
  • Exploring DAX calculated tables
  • Viewing DAX measures
  • Examining DAX calculated columns
• Data structure analysis
  • Retrieving schema information
  • Analyzing table relationships
  • Accessing table contents with pagination

The list of tools is configurable, so you can choose which tools you want to make available to the MCP client. This is useful if you don't use certain functionality or if you don't want to expose sensitive information.

Tools

Usage

WSL (Recommended)

Add the server configuration to your client configuration file. For example, for Claude Desktop:

{
  "mcpServers": {
    "pbixray": {
      "command": "wsl.exe",
      "args": [
        "bash",
        "-c",
        "source ~/dev/pbixray-mcp/venv/bin/activate && python ~/dev/pbixray-mcp/src/pbixray_server.py"
      ]
    }
  }
}

WSL Path conversion (Claude Project instructions for instance)

When using the PBIXRay MCP Server in WSL with Claude Desktop on Windows, you need to be aware of path differences when loading PBIX files. Windows paths (like C:\Users\name\file.pbix) cannot be directly accessed in WSL. Let your AI assistant know how to convert between pats by adding "Note that mcp server is running in wsl. Window

... View full README on GitHub