Best Practice Analysis
Best Practice Analyzer Report
Overview
Features
Prompts
Help
Key Features
Tabular Editor's Best Practice Analyzer is great at finding issues, but the export it hands you is a flat list of violations — no sense of which ones matter, no grouping, no priority. Working out what's serious means cross-referencing each line against Microsoft's 71-rule catalog and sorting it by hand, and there goes your afternoon. This skill reads the export for you, matches every finding to its rule, ranks them by severity, and hands back a clean report — critical issues first, the small stuff last, ready to share — run it with /bpa-analysis.
How it works
Before you start — this skill reads a BPA export, so you make that in Tabular Editor first (the free Tabular Editor 2 works fine). Open your model in Tabular Editor, go to Tools → Manage BPA Rules, and add Microsoft's rule set with Include Rule File from URL — paste https://raw.githubusercontent.com/microsoft/Analysis-Services/master/BestPracticeRules/BPARules.json, then untick the other rule collections so only these run. Run Tools → Best Practice Analyzer, expand every rule (the expand-all control is at the top right), select all the rows (Ctrl+A) and copy them, paste into Excel, and Save As → CSV (UTF-8, comma or semicolon delimited). Put that CSV in inputs/bpa/, or just tell Claude where you saved it and it'll move it for you.
Then type /bpa-analysis, point it to your BPA export, and the skill handles everything:
Loads Microsoft's full 71-rule BPA catalog (auto-downloads if missing)
Parses your Tabular Editor CSV export
Matches every rule — violated rules get flagged with severity, passed rules get confirmed
Sorts findings by severity (Critical > Warning > Informational) then by object count
Generates a summary with total rules evaluated, violations found, and objects affected
What you get
Full report (.md) — every violation with all affected objects listed
Compact report (.md) — up to 3 objects per rule with overflow counts, ready for stakeholder review
Structured data (.json) — machine-readable output for further automation
All files follow consistent naming: {project}_bpa_analysis_{date}_{time}.md
Explore more in this category

Bookmark Analysis
Analyze
Simulate bookmark navigation, detect visual leaks, and fix show/hide issues across bookmark chains.

Measure Killer Analysis
Analyze
Identify unused measures, DAX complexity issues, and dependency health across your entire model.

Pbip Analysis
Analyze
Check your star schema, relationships, DAX, Power Query, naming, and security all at once

Theme Auditor
Analyze
Scan all visuals for hardcoded colors, fonts, borders, and backgrounds that override the active theme
Tool Information
Skill
39 USD
Bundle (All skills)
129 USD
Category
Analyze
Version
Version 2.2.2.2
or log in if you already have an account

