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

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

MCP Reality

Power BI model tooling is host-specific. If your client exposes a Power BI modeling MCP server, inspect the available operations first and map them to the model areas you need: connections, tables, columns, measures, relationships, DAX queries, and security roles.

For Microsoft documentation, the Microsoft Learn MCP server is a good companion. Prefer:

microsoft_docs_search_by_product with power-bi
microsoft_docs_fetch for the final page

References & Resources

Documentation

STAR-SCHEMA - Dimension and fact modeling guidance
RELATIONSHIPS - Relationship patterns and cross-filter tradeoffs
MEASURES-DAX - DAX naming and measure design
PERFORMANCE - High-impact optimization ideas
RLS - Row-level security patterns

Scripts

Power BI Model Audit - Local audit helper for naming, documentation, and modeling smells

Examples

Model Examples - Example modeling patterns and DAX structure

Related Skills

Skill	Relationship
microsoft-development	Official Microsoft docs for Power BI capabilities and limits
sql-development	Shape the upstream warehouse or SQL source feeding the model
excel-sheet	Excel as a data source or export target

powerbi-modeling