Forum Discussion

PowerBI88's avatar
PowerBI88
Icon for Resolver I rankResolver I
5 years ago
Solved

Cannot 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

  • 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's avatar
      PowerBI88
      Icon for Resolver I rankResolver I

      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's avatar
        PowerBI88
        Icon for Resolver I rankResolver I

        In the end I performed a merge in the advanced editor