pbixray-mcp-server

pbixray-mcp-server

13

PBIXRay MCP Server is a tool that allows interaction with Power BI files (.pbix) through a Model Context Protocol (MCP) server. It offers features like data model exploration, query language access, and data structure analysis, making it easier for LLM clients to work with Power BI files.

PBIXRay MCP Server

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.

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

Tools

List of configurable tools available for interacting with Power BI files.

Command Line Options

Supports several options like disabling specific tools, setting maximum rows returned, and page size for paginated results.