MCP.so
Sign In

PBIXRay MCP Server

@jonaolden

Repository

About PBIXRay MCP Server

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.

#powerbi#claude#powerbi-reports#pbix-files#mcp-server

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "pbixray": {
      "command": "wsl.exe",
      "args": [
        "bash",
        "-c",
        "/path/to/pbixray-mcp/run_server.sh"
      ]
    }
  }
}

Tools

14

Core

Model

Model

Query

Query

Model

Query

Query

Query

Structure

Structure

Data

Model

Model

Overview

What is PBIXRay MCP Server?

PBIXRay MCP Server is a Model Context Protocol (MCP) server that exposes the capabilities of PBIXRay as tools and resources for LLM clients to interact with Power BI (.pbix) files. It is for developers and analysts who want to programmatically analyze Power BI data models.

How to use PBIXRay MCP Server?

Install via pip install pbixray-mcp-server or clone the repository and install in development mode. Add the server configuration to your MCP client (e.g., Claude Desktop JSON) using command and args for WSL or direct Python. Command-line options include --disallow, --max-rows, and --page-size. Tools support filtering by name and pagination for table contents.

Key features of PBIXRay MCP Server

  • Load and analyze PBIX files
  • List tables and retrieve model metadata
  • View Power Query (M) and DAX code
  • Examine DAX measures, calculated tables, and columns
  • Retrieve schema, relationships, and table contents with pagination
  • Configurable tool set via --disallow option

Use cases of PBIXRay MCP Server

  • Inspect the data model schema of a Power BI report
  • Extract DAX formulas for audit or documentation
  • Analyze table relationships across the model
  • Debug Power Query transformations in M code
  • Explore large table contents efficiently with pagination

FAQ from PBIXRay MCP Server

How does this differ from the tabular-mcp project?

Tabular-mcp is a follow-up project that allows running DAX queries against a local Power BI model, while PBIXRay MCP Server focuses on analyzing .pbix files by loading and exposing their structure and code.

Can I restrict which tools are available?

Yes, use the --disallow command-line option followed by tool names to disable specific tools for security purposes.

How do I handle Windows paths when running in WSL?

Add instructions to your client project notes: Windows paths (e.g., C:\Users\name\file.pbix) must be converted to WSL paths (e.g., /mnt/c/Users/name/Downloads/file.pbix) when loading files.

Does the server support pagination for large tables?

Yes, the get_table_contents tool supports page and page_size parameters. Default page size is 20 rows; maximum rows per request can be set with --max-rows.

What are the runtime dependencies?

Python packages: mcp, pbixray, and numpy. The server runs on any platform with a Python environment.

Frequently asked questions

How does this differ from the tabular-mcp project?

Tabular-mcp is a follow-up project that allows running DAX queries against a local Power BI model, while PBIXRay MCP Server focuses on analyzing .pbix files by loading and exposing their structure and code.

Can I restrict which tools are available?

Yes, use the `--disallow` command-line option followed by tool names to disable specific tools for security purposes.

How do I handle Windows paths when running in WSL?

Add instructions to your client project notes: Windows paths (e.g., `C:\Users\name\file.pbix`) must be converted to WSL paths (e.g., `/mnt/c/Users/name/Downloads/file.pbix`) when loading files.

Does the server support pagination for large tables?

Yes, the `get_table_contents` tool supports `page` and `page_size` parameters. Default page size is 20 rows; maximum rows per request can be set with `--max-rows`.

What are the runtime dependencies?

Python packages: `mcp`, `pbixray`, and `numpy`. The server runs on any platform with a Python environment.

Comments

Basic information

Category

Other

License

MIT

Transports

stdio

Author

jonaolden

More Other MCP servers

Inbox Zero AI MCP

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

πŸš€ Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

MaxKB

1Panel-dev

πŸ”₯ MaxKB is an open-source platform for building enterprise-grade agents. εΌΊε€§ζ˜“η”¨ηš„εΌ€ζΊδΌδΈšηΊ§ζ™Ίθƒ½δ½“εΉ³ε°γ€‚

22.0K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation β€’ (~400 MCP servers for AI agents) β€’ AI Automation / AI Agent with MCPs β€’ AI Workflows & AI Agents β€’ MCPs for AI Agents

23.2K