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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Power BI Left outer join not detected

Hello, I have to tables with the same name in the column where i want to make a left join 

 

Table A : 

nr63bi_0-1683298737306.png

 

Table B : 

nr63bi_1-1683298764221.png

 

 

But Power BI don't want to make the left join 

 

nr63bi_2-1683298787796.png

 

 

How to fix the problem ?

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

HI @Anonymous 

It is possible that the data type in two columns is different.
For example, one is text and the second is numbers.
This error message is not in English, so it's hard to understand.

Alternatively, if the reason is not a data type,
please attach the two tables you want to join.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

HI @Anonymous 

It is possible that the data type in two columns is different.
For example, one is text and the second is numbers.
This error message is not in English, so it's hard to understand.

Alternatively, if the reason is not a data type,
please attach the two tables you want to join.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors