pbixray-mcp-server
If you are the rightful owner of pbixray-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
PBIXRay MCP Server is a Model Context Protocol server that allows interaction with Power BI (.pbix) files using PBIXRay capabilities.
The PBIXRay MCP Server is designed to facilitate interaction with Power BI (.pbix) files by exposing the capabilities of the PBIXRay library. It allows users to load and analyze PBIX files, explore data models, access query languages, and analyze data structures. The server is configurable, enabling users to select which tools to make available to the MCP client, thus providing flexibility and security. It supports various command-line options and query parameters for efficient data handling and analysis. The server is particularly useful for developers and analysts working with Power BI data models, offering a comprehensive suite of tools for data exploration and manipulation.
Features
- Loading and analyzing PBIX files
- Data model exploration
- Query language access
- Data structure analysis
Tools
load_pbix_file
Load a Power BI (.pbix) file for analysis
get_tables
List all tables in the model
get_metadata
Get metadata about the Power BI configuration
get_power_query
Display all M/Power Query code used for data transformation
get_m_parameters
Display all M Parameters values
get_model_size
Get the model size in bytes
get_dax_tables
View DAX calculated tables
get_dax_measures
Access DAX measures with filtering by table or measure name
get_dax_columns
Access calculated column DAX expressions with filtering options
get_schema
Get details about the data model schema and column types
get_relationships
Get the details about the data model relationships
get_table_contents
Retrieve the contents of a specified table with pagination
get_statistics
Get statistics about the model with optional filtering
get_model_summary
Get a comprehensive summary of the current Power BI model
