Forum Discussion
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...
Ahh okay Merging is not joining. now I understand and for sure its a size issue that you are facing.
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.
For that you can use paramaters or if you have premium license you can use incremental refresh against your dataflows.
The issue is there and clear. reduce the size of your dataflows or move to Premium capacity and all will be good.