Cannot perfom Left join - no common join colum

[PowerBI88]

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

[amitchandak]

@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

[PowerBI88]

My pbix is all full of sensitive data I don't know how to remove them. I send you the table structure, maybe it can help. I am trying to join on fiscal code and vatnumber:

[PowerBI88 · Accepted solution]

In the end I performed a merge in the advanced editor