Hands-On-Lab: Managing Relationships in Power BI

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

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.

Get weekly learning resources from SQLMaestros, right in your inbox. Subscribe to our Bulletins.