Used as a dependency for data processing operations in the PBIXRay server, supporting statistical analysis and data manipulation of Power BI models.
A Model Context Protocol (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.
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.
| Tool | Category | Description |
|---|---|---|
load_pbix_file | Core | Load a Power BI (.pbix) file for analysis |
get_tables | Model | List all tables in the model |
get_metadata | Model | Get metadata about the Power BI configuration |
get_power_query | Query | Display all M/Power Query code used for data transformation |
get_m_parameters | Query | Display all M Parameters values |
get_model_size | Model | Get the model size in bytes |
get_dax_tables | Query | View DAX calculated tables |
get_dax_measures | Query | Access DAX measures with filtering by table or measure name |
get_dax_columns | Query | Access calculated column DAX expressions with filtering options |
get_schema | Structure | Get details about the data model schema and column types |
get_relationships | Structure | Get the details about the data model relationships |
get_table_contents | Data | Retrieve the contents of a specified table with pagination |
get_statistics | Model | Get statistics about the model with optional filtering |
get_model_summary | Model | Get a comprehensive summary of the current Power BI model |
Add the server configuration to your client configuration file. For example, for Claude Desktop:
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. Windows paths (like C:\Users\name\file.pbix) cannot be directly accessed in WSL. Instead, use WSL paths when referencing files:
Windows: C:\Users\name\Downloads\file.pbix"
WSL: /mnt/c/Users/name/Downloads/file.pbix" to project instructions or similar.
The server supports several command line options:
--disallow [tool_names]: Disable specific tools for security reasons--max-rows N: Set maximum number of rows returned (default: 100)--page-size N: Set default page size for paginated results (default: 20)Command-line options can be added as needed in config json:
Tools support additional parameters for filtering and pagination:
Tools like get_dax_measures, get_dax_columns, get_schema and others support filtering by specific names:
The get_table_contents tool supports pagination to handle large tables efficiently:
You can install PBIXRay MCP Server:
For developers working on the project:
The repository includes sample files and test scripts to help you get started:
The test scripts will help you understand how to interact with the server using the sample PBIX files provided in the demo/ directory.
To test the server during development, use the MCP Inspector:
This starts an interactive session where you can call tools and test responses.
Contributions are much welcomed!
This server cannot be installed
local-only server
The server can only run on the client's local machine because it depends on local resources.
A Model Context Protocol enabling AI clients to interact with PowerBI Models by querying metadata through PBIXRay python package.