Forum Discussion

decarsul's avatar
decarsul
Helper V
5 years ago
Solved

PC crashes when doing a left join

Gday all!   This week i've been having an issue with a powerquery left join. I have 2 tables, table 1 contains an id that corresponds with a unique id in table 2. Now i want to join just 1 column...
Need Help
Tips and Tricks
  • aj1973's avatar
    aj1973
    5 years ago

    Ahh okay Merging is not joining. now I understand and for sure its a size issue that you are facing.

     

decarsul's avatar
decarsul
Helper V
5 years ago

I do the left join from PowerQuery, not from DAX relationmanager if that's what you mean.

aj1973's avatar
aj1973
Community Champion
5 years ago

Sorry but why using PowerQuery for joining? Power Query is good for ETL (Extraction, transformation and loading). Modeling(joins and relationships) is done in power bi desktop and DAX.

 

  • decarsul's avatar
    decarsul
    Helper V
    5 years ago

    Maybe we're not understanding. I geuss a better translation would be 'merging'?

    The reason i'm doing it in Powerquery is so that i don't have to load the table that contains more data than i need to the model. But i need it to create a unique id so can i can make a relationship to another table.

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      Ahh okay Merging is not joining. now I understand and for sure its a size issue that you are facing.