Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
IS_MN
Frequent Visitor

Power BI ditects table join incorrectly as many-to-many

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?

 

Thanks.

8 REPLIES 8
v-frfei-msft
Community Support
Community Support

Hi @IS_MN,

 

Could you please disable the option Autodetect new relationships after data is loaded and import the data again?

 

2.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi @IS_MN,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi Frank,

 

Thanks for your reply. I already tried that path and yet had the same issue.

 

Thanks,

Ishret

affan
Solution Sage
Solution Sage

Hi @IS_MN

 

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 .

 

Regards,

Affan

 

IS_MN
Frequent Visitor

Hi Affan,

 

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.

 

Thanks,

Ishret

Hi @IS_MN can you share the pbix?

IS_MN
Frequent Visitor

Due to data privacy, I'm unable to share the pbix - sorry!

 

Thanks,

 

Ishret

Iris_
Frequent Visitor

Hi Ishret,
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...

Best,

Iris

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.