Skip to main content

Modelling for Power BIs

Modelling in Power BI means arranging tables and relationships so reports calculate correctly and quickly. The usual target is a star schema, with fact tables holding events and dimension tables holding descriptions. It happens in Model view, after Power Query cleans the data and before DAX measures are written.

Stage: Data Preparation · Part of the Power BI roadmap · Last reviewed 19 November 2026

What to learn in Modelling

Modelling interview questions

Why is a star schema recommended for Power BI models?

A star schema keeps facts and dimensions separate, so filters flow cleanly from dimensions to facts. It compresses well in the VertiPaq engine, keeps DAX simpler, avoids ambiguous paths between tables and usually gives faster visuals than one wide flat table.

What is cardinality in a Power BI relationship?

Cardinality describes how rows in two tables match: one-to-many, one-to-one or many-to-many. The common case is one-to-many, where a dimension key is unique and appears many times in the fact table. Wrong cardinality produces incorrect totals or blank results.

Where Modelling fits in the Power BI roadmap

Modelling belongs to the Data Preparation stage (beginner level), which takes about 14 hours. Connect and clean.

Back to the full Power BI roadmap