Create relationships

Step 1: Also load the Product and Region tables from the practice file (Home → Get data → Excel workbook), then switch to Model view to see all your tables as cards.

Step 2: Drag a key column (for example ProductID) from one table onto the matching column in another.

Step 3: Check the cardinality (usually one-to-many, 1 → *) and that the relationship is active (a solid line, not dashed).