PBIXRay MCP Server
MCP server using PBIXRay to analyze Power BI (.pbix) files. Enables AI agents to inspect Power BI report internals — DAX measures, data models, relationships, data sources, and metadata — without requiring Power BI Desktop. Useful for Power BI governance, auditing, and documentation automation.
Score Breakdown
⚙ Agent Friendliness
🔒 Security
.pbix files may contain connection credentials. Local analysis only. No external access. Protect pbix files accordingly.
⚡ Reliability
Best When
A Power BI developer or BI admin wants AI agents to audit, document, or analyze the internals of Power BI .pbix files — understanding data model structure, DAX complexity, and data source dependencies.
Avoid When
You need to interact with live Power BI reports or embed reports. PBIXRay analyzes the file format — not the live service.
Use Cases
- • Auditing Power BI report data models and DAX measures from governance agents
- • Documenting Power BI report structure and dependencies from documentation agents
- • Analyzing Power BI file internals for migration and optimization agents
- • Extracting Power BI metadata for catalog and lineage tracking agents
Not For
- • Rendering Power BI visuals (file analysis only, not live report rendering)
- • Teams without Power BI .pbix files to analyze
- • Real-time Power BI dashboard interaction (use Power BI REST API for that)
Interface
Authentication
No authentication — local file analysis tool. Reads .pbix files from local filesystem.
Pricing
Free open source using PBIXRay library.
Agent Metadata
Known Gotchas
- ⚠ .pbix files are binary Microsoft format — PBIXRay decodes them but coverage may be incomplete
- ⚠ Power BI file format can change with Power BI Desktop versions — verify version compatibility
- ⚠ Large .pbix files with complex models may take significant time to parse
- ⚠ Report metadata and credentials embedded in .pbix files are sensitive — handle with care
Alternatives
Full Evaluation Report
Detailed scoring breakdown, competitive positioning, security analysis, and improvement recommendations for PBIXRay MCP Server.
Scores are editorial opinions as of 2026-03-06.