Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained

Many times while working with relational data, the need to get context information from other data tables and sources will arise. Understanding how to perform modelling when working with such situations is essential. Let us look at some data modelling concepts when working in Power Bi. Joins In Power Bi, joins are called Merge queries. This is when two tables are joined together depending on matching values from columns. At least once column in the two tables must have matching values eg. an id appearing both in users table and a similar matching id value appearing in subscriptions table. The names of the two columns do not need to be same, but the underlying values must match. In most cases, this involves a primary key from one table and a foreign key in the other table. To perform joins in Power Bi, we select Merge queries command from the home tab. Image from learn.microsoft.com Several types of joins are available in Power Bi: inner join: returns only matching rows from both the le