Power BI Modeling

Use this skill when the work is inside a Power BI semantic model rather than a generic SQL schema or spreadsheet.

Activation Conditions

• Designing or cleaning up a star schema
• Creating or reviewing DAX measures
• Configuring relationships and cross-filter direction
• Implementing row-level security
• Auditing model health and performance

Practical Workflow

1. Inspect the current model before changing anything.
2. Classify tables as dimension, fact, bridge, or helper tables.
3. Prefer explicit measures over implicit aggregation.
4. Keep relationships simple and single-direction unless the use case is proven.
5. Hide technical fields from report authors.