![](https://sessionize.com/image/1fcf-400o400o1-ae-3afd-46f5-a490-03a77b854c0b.b3f35d4c-e115-4f75-9005-b7618794cdd9.jpg)
SQLBits 2019
Different types of many-to-many relationships in Power BI
Clarify differences between many-to-many and weak relationships in Power BI
The introduction of the weak relationships in Power BI composite models enables new data modeling techniques. However, not all of the many-to-many relationships can be managed by using weak relationship.
The "classical" many-to-many relationships in data warehouse is a design pattern requiring a bridge table, which is not required by a weak relationship in Power BI. The weak relationship can establish another type of many-to-many relationship that is different from the one commonly used in dimensional modeling, and it commonly solves a granularity issue in managing data coming from different data sources.
This session clarifies design patterns and best practices for using weak relationships and implementing different type of many-to-many relationships in Power BI.
The "classical" many-to-many relationships in data warehouse is a design pattern requiring a bridge table, which is not required by a weak relationship in Power BI. The weak relationship can establish another type of many-to-many relationship that is different from the one commonly used in dimensional modeling, and it commonly solves a granularity issue in managing data coming from different data sources.
This session clarifies design patterns and best practices for using weak relationships and implementing different type of many-to-many relationships in Power BI.