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
コメント