PAO Automation — PBIT Schema Parser & Diff Engine interface and evaluation output
Figure 01 — PAO AutomationOpen full resolution ↗

notesarchitecture & scope

PAO Automation is a Python engineering utility built to eliminate manual Power BI report auditing and documentation. By inspecting the internal data model and layout schemas inside Power BI Template (.pbit) archives, it produces deterministic documentation and version diffs in seconds.

Key Capabilities

  • Automated DAX measure, calculated column, and table extraction from PBIT schemas
  • Dead-object analysis — flags measures, columns, and tables unreferenced by any visual, filter, or dependency tree
  • Cross-visual usage graph mapping measures to report pages and bookmarks
  • Side-by-side PBIT version diffing — detects added, removed, modified, and renamed objects across report releases
  • Automated DOCX technical specification and color-coded Excel inventory export
  • Desktop Tkinter interface for batch inspection and diagram injection

Turns hours of error-prone manual BI change-management documentation into a repeatable build step.