Forum Discussion
PowerBI88
Resolver I
5 years agoCannot perfom Left join - no common join colum
Hi,
I am unable to perform the left join between two tables of my model, even though the tables have columns with the same name.
Here is the error:
As regards the data source, one table comes from a text csv file instead the other comes from a zipped csv file from a network share.
Can you provide me support as regards the join?
Thank you,
Kind regards,
Marta
In the end I performed a merge in the advanced editor
3 Replies
- amitchandak
Super User
PowerBI88 , Natrualleftjoin can be a bit of a challenge even with the same column name.
Can you share a sample pbix after removing sensitive data.
This link has good example, if you want to refer