Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
once i create many to many relationship between two tables after that i am unable to create one to many relationship with other tables.
suppose i have 3 tables A,B,C . Tables B and C have many to many relationship on column hournumber and now i try to create one to many relationship between tables A and B on column clientId but unable to create this relationship.
Thanks
Shyamji
Solved! Go to Solution.
This is because of your many-to-many relationships, or bidirectional filters. You should study this document from MS. You may be able to avoid Many to Many using bridge tables or other methods. Many to Many can be good in the right circumstances, but it causes issues. I use them as a very LAST resort. I prefer bridge tables as they keep the model a bit cleaner and you avoid the ambiguity problems. They, however, don't solve all issues. It is a matter of what works best in your scenario.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCan you go to your model tab, give us a screenshot of what that looks like, then right-click on any table, click Manage Relationships, and show us what it is not allowing you to do when you create a new relationship?
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingA great thanks for reply ,
please review below screenshot
Thanks for reply.
please go through below screenshot
This is because of your many-to-many relationships, or bidirectional filters. You should study this document from MS. You may be able to avoid Many to Many using bridge tables or other methods. Many to Many can be good in the right circumstances, but it causes issues. I use them as a very LAST resort. I prefer bridge tables as they keep the model a bit cleaner and you avoid the ambiguity problems. They, however, don't solve all issues. It is a matter of what works best in your scenario.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
76 | |
74 | |
61 | |
61 | |
45 |
User | Count |
---|---|
108 | |
103 | |
93 | |
83 | |
64 |