jonaolden_pbixray-mcp-server
If you are the rightful owner of jonaolden_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 LLM clients to interact with Power BI (.pbix) files using PBIXRay's capabilities.
The PBIXRay MCP Server is designed to facilitate interaction with Power BI (.pbix) files by exposing the capabilities of PBIXRay as tools and resources for LLM clients. It provides functionalities such as loading and analyzing PBIX files, exploring data models, accessing query languages, and analyzing data structures. The server is highly configurable, allowing users to select which tools to make available, thus ensuring security and privacy. It supports command-line options for further customization, including disabling specific tools and setting pagination parameters. The server is compatible with various platforms, including WSL, and offers detailed instructions for development and testing.
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
