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.
I am having Table named as the Date which is having Column related the Date Hirarchy and another table is Maintenence table which is having Maintenence date in table as well as datekey in table. This both date are having Same data type in table but stil i am not able to create the realtionship between this two dates. I am creating the relation ate date column for one to many raltionship. suggest me a better way to handle this scenario
Solved! Go to Solution.
While creating such relationship you must make sure that Date(Dimension) Table not having any duplicates.
since that table has got duplicates it is causing many to many relationship.
Proud to be a Super User!
Thanks For Solution I had made some changes and implmented again and it worked.
If you find solution , please mark Accept as Solution and share your kudos
Proud to be a Super User!
While creating such relationship you must make sure that Date(Dimension) Table not having any duplicates.
since that table has got duplicates it is causing many to many relationship.
Proud to be a Super User!
Thanks For Solution I had made some changes and implmented again and it worked.
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |