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

And also,

 

Does this apply only to the online workspace, or also to the desktop client?

aj1973's avatar
aj1973
Community Champion
5 years ago

Answering all your 3 questions:

  1. Limits count for free and Pro licenses
  2. The 10GB size is the limite for a workspace not for a Dataset. one workspace can contain many Datasets, one dataset can't be more than 1GB size, size of all Datasets can't go over 10GB in A workspace
  3. Same answer as question 2

 

  • decarsul's avatar
    decarsul
    Helper V
    5 years ago

    Than this is most likely my issue, because the dataflows combined will gross out over 1GB.

    But why then does this not give a warning or error. But instead gets 'stuck' in a loop of sorts and eats up all the system resources to a point it can nolonger function?

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      I don't have an aswer to this question, it could be related to many things.

      But I know for sure that work can be done on your dataset and/or your dataflows to get what you need.

       

      • decarsul's avatar
        decarsul
        Helper V
        5 years ago

        I know it can too. For now i've added a filter before joining, so that i don't load in 10 years of data, but instead load in the last 2 quarters, effectively making the dataset total smaller.