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.
Hi ,
I am trying to create a relationship between two tables, Calls and Calls Details in PBI desktop. But I am getting this below error. Does anybody know how to solve below error ? Any suggestion would be helpful.
Thanks in advance !
Solved! Go to Solution.
Hi @Anonymous,
Based on the above error message, there are some issues in the relationship between Calls and Calls Details tables.
Actually, Power BI supports One to Many and One to One relationships not Many to Many relationship.
Could you please sample data or 'Calls (callid)' and 'Calls Details(callid)' ? Do each field contain unique values? Which table is Many side of the relationship and which table is One side of the relationship?
Best Regards,
Cherry
Hi @Anonymous,
Based on the above error message, there are some issues in the relationship between Calls and Calls Details tables.
Actually, Power BI supports One to Many and One to One relationships not Many to Many relationship.
Could you please sample data or 'Calls (callid)' and 'Calls Details(callid)' ? Do each field contain unique values? Which table is Many side of the relationship and which table is One side of the relationship?
Best Regards,
Cherry
Hi @v-piga-msft thank you for your reply. I checked the calls table , and it doesnot contain unique 'callid'. It seems this error replicates , “Many-to-Many” relationship error of power bi.
Hi @Anonymous,
Have you solved your problem?
If you have soleved, only thing that you'll have to notice, just 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
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |