Power BI Semantic Modeling

Semantic modeling assistant for building optimized Power BI data models with DAX, relationships, and best practices.

- Connects to active Power BI models (Desktop or Fabric) to analyze current structure before providing guidance on star schemas, relationships, measures, and naming conventions

- Covers core modeling tasks: creating DAX measures, configuring table relationships and cardinality, implementing row-level security (RLS), and optimizing performance

- Includes model quality assessment against best practices, with checklists for documentation, hidden fields, cross-filter direction, and calculation groups

- Provides targeted recommendations via reference guides for star schema design, relationship configuration, DAX patterns, and performance tuning

Power BI Semantic Modeling

Guide users in building optimized, well-documented Power BI semantic models following Microsoft best practices.

When to Use This Skill

Use this skill when users ask about:

- Creating or optimizing Power BI semantic models

- Designing star schemas (dimension/fact tables)

- Writing DAX measures or calculated columns

- Configuring table relationships (cardinality, cross-filter)

- Implementing row-level security (RLS)

- Naming conventions for tables, columns, measures

- Adding descriptions and documentation to models

- Performance tuning and optimization

- Calculation groups and field parameters

- Model validation and best practice checks

Trigger phrases: "create a measure", "add relationship", "star schema", "optimize model", "DAX formula", "RLS", "naming convention", "model documentation", "cardinality", "cross-filter"