jonaolden_pbixray-mcp-server

jonaolden_pbixray-mcp-server

0

The PBIXRay MCP Server is an MCP server designed to work with PBIXRay, enabling interaction with Power BI files. It allows for data model exploration, query language access, and data structure analysis, making it customizable and secure for various use cases.

PBIXRay MCP Server

A Model Context Protocol (MCP) server for PBIXRay that facilitates interaction 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
    • 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

  • Various tools for loading, analyzing, and querying Power BI files with customizable configurations for security and privacy.

Usage

  • Configuration options for using the server with Windows Subsystem for Linux (WSL).

Development and testing

  • Installation via pip
  • Instructions for setting up a development environment
  • Testing with sample files

Contributions

Contributions are welcomed.

Credits

  • Hugoberry - Original PBIXRay library
  • rusiaaman - WCGW contribution

License

MIT License