Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |