Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 : 

 

Table B : 

 

 

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

 

 

 

How to fix the problem ?

 

 

  • 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.

1 Reply

  • 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.