I'm trying to join two tables and none of them has any duplicate values. Power BI keeps bringing error saying incorrect join as it detects many-to-many relationship. Anyone had this error?
Could you please disable the option Autodetect new relationships after data is loaded and import the data again?
Does that make sense? If so, kindly mark my answer as a solution to close the case.
There can be issues with creating relationships in power bi even your values are uniqe but still the data source is having some row with null value.
You can see the below video and give it a try. I hope this helps to resolve your issue.
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Thanks for your message and suggestion. However, I've already removed nulls from the table and still got the error. Should've mentioned it in my original post I suppose.
Have you found a solution for this issue? I have met the same.
The dimention table is applied with steps of revoming duplicates, removing empty and even grouping. But Powerbi still claims that the DIM table will introduce many to many relationship...
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.