Mastering Microsoft Power BI

Fact-to-dimension relationships

To create the Data Model relationships identified in the Data Warehouse Bus Matrix image:

1. Click Manage Relationships from the Modeling tab in Report View.
2. From the Manage Relationships dialog, click the New command button at the bottom to open the Create relationship interface. Choose the fact table, such as Internet Sales, for the top table via the dropdown and then select the dimension table as shown in the following screenshot:

Creating a relationship for the import mode dataset

If the relationship columns have the same name, such as Currency Key in this example, Power BI will automatically select the columns ...