Power BI Exercises

Drivers matched to the wrong key

Data Modeling · Advanced · Chapter 5 of 10. Create and fix relationships in the Model view, and see why they matter.

The request, from Giulia Moretti, Owner, Slice & Co.: "Only four of our six drivers show any revenue. Everyone was out delivering, I promise." A table of revenue by vehicle, with the Driver relationship on the right columns.

A relationship on the wrong columns is worse than none: the numbers look plausible but are wrong. Here Orders[StoreID] was linked to Driver[DriverID]. Both are small whole numbers, so Power BI did not complain.

Task: Delete the relationship Orders[StoreID] → Driver[DriverID].

Task: Connect Orders[DriverID] to Driver[DriverID].

Practice data: Slice & Co., a fictional pizza restaurant chain. The model has the Orders, Pizza, Store, Driver and Calendar tables.

How it works: the exercise opens a practice copy of the Power BI report editor in your browser. Do the task, press Check, and your result is compared with the expected answer in seconds. Hints are there if you get stuck.

Keep practicing