Skip to main content Link Menu Expand (external link) Document Search Copy Copied
Fabric w/ Azure Databricks

Task 02: Create relationships

Establish relationships between the tables within the semantic model. This step is crucial for creating a coherent data model that accurately reflects the intricacies of Contoso’s operations, ensuring that the reports generated provide meaningful insights.

  1. In the upper left, select Home.

  2. Under the Home tab, on the menu, select the Refresh icon.

    refresh3.jpg

    This refresh is required for the workspace to show the proper objects.

    There should be four tables in the view. Use the Scale sliders to adjust the view as necessary.

  3. Drag factSales > CustomerIDKey to dimCustomer > CustomerIDKey to create the relationship between the two tables.

    dragtableitemx.gif

  4. In the New relationship window, select the Assume referential integrity checkbox and then select Save.

  5. Drag factSales > ProductIDKey to dimProduct > ProductIDKey

  6. In the New relationship window, select Assume referential integrity and then select Save.

  7. Drag factSales > OrderDate to dimDate > Date.

    On the following New relationship window, DO NOT select the Assume referential integrity. option.

    new-relationship.png

  8. On the New relationship window, keep the default settings and select Save.