power-bi-agent-skills: Skill for Claude Code

Best Practices Skill

This skill helps apply Power BI best practices, Best Practice Analyzer (BPA) rules, and enterprise standards to semantic models and reports.

When to Use This Skill

• Validating model quality against BPA rules
• Applying naming conventions
• Optimizing model performance
• Adding documentation and descriptions
• Enforcing enterprise governance patterns
• Reviewing DAX measures for quality

Best Practice Analyzer (BPA) Overview

BPA rules are organized into categories:

1. Performance - Optimization and efficiency rules
2. DAX Expressions - Measure and calculation quality
3. Formatting - Naming and organization standards
4. Maintenance - Housekeeping and cleanup rules
5. Error Prevention - Validation and safety rules

Quick Validation Checklist

Model Structure

• All tables have descriptions
• Relationships are one-to-many (no bi-directional unless required)
• Key columns are marked as hidden
• Date table is marked as date table
• No unused columns or tables

DAX Measures

• All measures have descriptions (/// comments)
• DIVIDE() used instead of / operator
• Variables used for repeated expressions
• Measures organized in display folders
• No implicit measures (summarizations)

Naming Conventions

• Tables: PascalCase, singular nouns
• Columns: PascalCase with spaces allowed
• Measures: Business-friendly names
• No special characters or reserved words

Performance

• No calculated columns where measures work
• Integer keys instead of string keys
• Narrow tables preferred (fewer columns)
• Appropriate data types used

Performance Rules

HIGH IMPACT

Avoid bi-directional relationships

Bi-directional relationships cause performance overhead and can create ambiguity.

Instead of:

relationship {{guid}}
	fromColumn: TableA.'Key'
	toColumn: TableB.'Key'
	crossFilteringBehavior: bothDirections

Do this:

relationship {{guid}}
	fromColumn: TableA.'Key'
	toColumn: TableB.'Key'

// Use DAX CROSSFILTER() in measures when needed
measure 'Filtered Value' =
	CALCULATE(
	    [Base Measure],
	    CROSSFILTER(TableA[Key], TableB[Key], Both)
	)