powerbi-modelling

name	powerbi-modelling
description	Power BI semantic modelling assistant for building optimised data models. Use when working with Power BI semantic models, creating measures, designing star schemas, configuring relationships, implementing RLS, or optimising model performance. Triggers on queries about DAX calculations, table relationships, dimension/fact table design, naming conventions, model documentation, cardinality, cross-filter direction, calculation groups, and data model best practices. Always connects to the active model first using power-bi-modelling MCP tools to understand the data structure before providing guidance.
metadata	{"skill-author":"Marie-Lynne Block"}

Power BI Semantic Modelling

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

When to Use This Skill

Use this skill when users ask about:

• Creating or optimising 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 optimisation
• Calculation groups and field parameters
• Model validation and best practice checks

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

Prerequisites

Required Tools

• Power BI Modelling MCP Server: Required for connecting to and modifying semantic models