Dummy BI

Features

Everything Dummy BI Automate can do for your Power BI workflow.

Report Documentation

Extracts complete metadata from a PBIP project (Power BI's open file format) into a structured Excel workbook: 25+ sheets covering visuals, measures, DAX dependencies, filters, bookmarks, relationships, security roles, hierarchy levels, and more. One command, full picture.

25+ sheets. Single source of truth. No separate parsers.

Report Documentation demo

Datasource Switching

Rewrites an entire Power BI report to point at a different dataset. A 6-phase visual wizard maps tables, columns, measures, hierarchies, calculation groups, and field parameters. Rewrites TMDL model files (the text-based semantic model format), PBIR JSON, and DAX expressions.

6-phase wizard. Full bidirectional sync. All Power BI object types.

Datasource Switching demo

Report Health Monitor

Cross-references documentation output to detect: ghost slicers, ghost visuals, orphaned hidden pages, duplicate slicers, empty containers, unused measures and columns. Detects report-layer usage that model-only tools miss.

Catches usage in visuals, filters, and bookmarks that purely model-side tools miss.

Report Health Monitor demo

DevOps Diff

Compares two Report_Documentation.xlsx files and produces a structured diff: adds, removes, modifications — per sheet, per row. Generates Markdown summary for PR comments. CI/CD exit codes: 0 = no changes.

CI/CD ready. Works in any pipeline that can run a Python command.

DevOps Diff demo

Dependency Graph

Shows every transitive dependency of every measure, column, and visual. Identifies what is safe to remove without breaking the report.

Full backward BFS walk from report-layer usage through model dependencies.

Dependency Graph demo

Report Prototype Generator

Captures visual layout metadata and generates Excalidraw wireframes of each report page — layout-accurate, derived from documentation metadata.

Works offline. No screenshots required.

Report Prototype Generator demo

Template Export

Exports a report as a sanitised marketplace bundle (.reportbundle.zip): strips datasource references, credentials, and connection strings. Ready for the Dummy BI marketplace.

Output format used by the Dummy BI marketplace.

Online Operations — ProPro

Connect to a Power BI workspace via Fabric API or XMLA endpoint (Microsoft's administration protocol for Analysis Services). Switch, document, audit, and batch-operate across workspace reports without manual download/upload cycles.

Pro tier. Fabric API: any Fabric capacity. XMLA: Premium/PPU/Fabric.

Glossary

PBIP
Power BI Project — Microsoft's open, file-based format for Power BI reports.
TMDL
Tabular Model Definition Language — text-based format for Power BI semantic models.
DAX
Data Analysis Expressions — the formula language used in Power BI measures and calculated columns.
XMLA
XML for Analysis — Microsoft's administration protocol for managing Analysis Services datasets remotely.