Pbip Analysis
85-Rule Model Health Check
Analyze
Overview
Features
Prompts
Troubleshooting
Key Features
No single tool checks star schema compliance, relationship health, DAX patterns, Power Query architecture, naming conventions, and security in one pass. You end up reviewing TMDL files manually and checking topology by hand. This skill reads your PBIP project directly, evaluates 85 rules across 10 categories, and produces a complete structural health report — no exports needed.
How it works
Type /pbip-analysis, point it to your PBIP project, and the skill reads the model directly:
Parses all TMDL files from the semantic model definition
Parses report definitions from the Report folder
Evaluates 85 rules across 10 categories
Builds supplementary analysis: relationship topology with fact/dim classification, DAX function frequency, Power Query source inventory
What you get
Full report (.md) — all findings with affected objects
Compact report (.md) — summarized for quick review
Structured data (.json) — for automation
Relationship topology — fact vs dimension classification with relationship diagram
DAX function frequency — top 20 most-used functions across all measures
Power Query source inventory — connectors and step counts per query
All files follow consistent naming: {project}_pbip_analysis_{date}_{time}.md
Explore more in this category
Best Practice Analysis
Analyze
Parse Tabular Editor BPA exports, match against 71 Microsoft rules, and generate a prioritized findings report.
Bookmark Analysis
Analyze
Simulate bookmark navigation, detect visual leaks, and fix show/hide issues across bookmark chains.
Color Analysis
Analyze
Extract every color assignment across all visuals, resolve theme colors to hex, and flag discrepancies.
Interactions Matrix
Analyze
Generate, edit, and compare visual interaction matrices showing who affects whom on each page.