To create logical connections between multiple sources for better analysis, we create relationships between the sources. The data from different data sources can then be joined for further analysis. This process of creating relationships comes under data modelling. In this lab, we’ll learn to create and manage relationships between multiple source files. In the first exercise, we will learn about Relationship view in Power BI desktop. In the second exercise, we will learn to autodetect relationships between imported data and to create manual relationships. In the third exercise,we will learn to Assume Referential integrity.
Exercise 1: Relationship view in Power BI Desktop
Exercise 2: Create and Manage Relationships In Power BI
Exercise 3: Assume Referential integrity