cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

7 REPLIES 7
Highlighted
Solution Sage
Solution Sage

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

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

 

Highlighted
Frequent Visitor

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

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

Highlighted
Solution Sage
Solution Sage

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

Hi @IS_MN can you share the pbix?

Highlighted
Community Support
Community Support

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

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.
Highlighted
Community Support
Community Support

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

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.
Highlighted
Frequent Visitor

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

Hi Frank,

 

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

 

Thanks,

Ishret

Highlighted
Frequent Visitor

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

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

 

Thanks,

 

Ishret

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors