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.
Solved! Go to Solution.
Hi @Anonymous ,
For this case, we do not recommend use many to many relationship in data model, usually create many-one-many relationships by a transitionary dim table instead as you said.
You can refer the following Microsoft documents that help you:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
For this case, we do not recommend use many to many relationship in data model, usually create many-one-many relationships by a transitionary dim table instead as you said.
You can refer the following Microsoft documents that help you:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Potentially many problems. Sorry bad joke. Hard to say definitely without knowing more about your data model and how this many-to-many is being used.
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |