Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Please see error I'm receiving below, for some reason I keep on receiving this error when I try to refresh my data. I talked to our DB SQL administrator and he says that the table doesn't have this restriction and believes it's a PowerBI issue.
Does anyone know what can be causing this issue and how to fix it?
Solved! Go to Solution.
Hi @Dali748 ,
Please refer to the document below about creating many to many relationship in power bi.
https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships
Best Regards,
Cherry
Relationship column on one side of relationship cannot have duplicate values. Either remove duplicates from Column or create Many to Many relationships.
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.
Hi @Dali748 ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Dali748 ,
Please refer to the document below about creating many to many relationship in power bi.
https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |