Forum Discussion

decarsul's avatar
decarsul
Icon for Helper V rankHelper 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.

     

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Sorry I didn't get your scenario! You have 2 dataflows, you call these dataflows to your Desktop and you pick different entities from these 2 Dataflows. In your model you try to join (relationship) 2 entities from those 2 dataflows and your system crashes?

Is this your issue?

 

decarsul's avatar
decarsul
Icon for Helper V rankHelper 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
    Icon for Community Champion rankCommunity 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
      Icon for Helper V rankHelper 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
        Icon for Community Champion rankCommunity Champion
        5 years ago

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