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

Local serverstdioPython

What is the 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.

What it actually does

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

  • Loading and analyzing PBIX files
  • Data model exploration
  • Listing tables in the model
  • Retrieving model metadata
  • Checking model size
  • Getting model statistics

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
load_pbix_fileCore
get_tablesModel
get_metadataModel
get_power_queryQuery
get_m_parametersQuery
get_model_sizeModel
get_dax_tablesQuery
get_dax_measuresQuery
get_dax_columnsQuery
get_schemaStructure
get_relationshipsStructure
get_table_contentsData
get_statisticsModel
get_model_summaryModel

How to install the PBIXRay MCP Server

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

Configuration as documented by the project. Restart the client after saving.

Example prompts to try

  • “Use PBIXRay to load pbix file.”
  • “Use PBIXRay to get tables.”
  • “Use PBIXRay to get metadata.”

Frequently asked questions

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.