Forum Discussion
Many ro many relationships
Why cant I create many to many relationships in the lakehouse(fabric)?
Hi Aravindanbu3012 ,
The problem you're describing isn't the inability to create pairs of multiple pairs in lakehouse. Rather, it's the constraints that the semantic model is designed to place on the columns that create the many-to-many relationships. As shown in the following message when you create a many-to-many relationship:
For more information about many-to-many relationship, you can refer to below document:
Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Aravindanbu3012 ,
The problem you're describing isn't the inability to create pairs of multiple pairs in lakehouse. Rather, it's the constraints that the semantic model is designed to place on the columns that create the many-to-many relationships. As shown in the following message when you create a many-to-many relationship:
For more information about many-to-many relationship, you can refer to below document:
Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I encountered an issue in the Lakehouse within the Fabric where there wasn't an option for establishing many-to-many relationships. I resolved this by creating a new semantic model outside of the Lakehouse, which offers the capability to establish many-to-many relationships.
