PBIXRay icon

PBIXRay

Createdjonaolden

Analyze Power BI models and reports (.pbix files) using AI.

About

PBIXRay is an MCP server that leverages AI to analyze Power BI models and reports (.pbix files). It exposes the capabilities of PBIXRay as tools and resources, enabling Large Language Model (LLM) clients to interact with Power BI files. This allows for detailed exploration of data models, access to query languages (M and DAX), in-depth data structure analysis, and configurable tool selection for customized functionality and security.

Key Features

  • 1 GitHub stars
  • Performs data structure analysis (retrieving schema information and analyzing table relationships).
  • Explores data models (listing tables, retrieving metadata, checking model size, getting model statistics, and generating comprehensive summaries).
  • Retrieves table contents with pagination for efficient handling of large datasets.
  • Loads and analyzes PBIX files.
  • Provides query language access (viewing Power Query M code, accessing M parameters, exploring DAX calculated tables, viewing DAX measures, and examining DAX calculated columns).

Use Cases

  • Automating data extraction from Power BI reports using AI.
  • Analyzing Power BI data models for optimization.
  • Integrating Power BI data analysis into LLM workflows.
Craft Better Prompts with AnyPrompt