BBampaa

Lessons › Power BI

Power BI lesson

Data model and relationships

Connect the tables

Try this lesson free →
About 5–10 minutes · no sign-up needed

Key points

Fact tableSales: one row for every sale. The numbers live here.
Dimension tableProducts: one row per product, with details like category.
RelationshipJoins them on a shared ID, so filters flow between tables.

Connect Sales[ProductID] to Products[ProductID], and every product detail becomes usable in your visuals.

In Power BI Desktop

Open Model view and drag ProductID from Sales onto ProductID in Products. Power BI often finds the relationship for you when the names match.

Practice

Try each one in your head first, then open the answer.

1. Which of these is the fact table?
Sales: one row for every sale

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed