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.
here are 2 articules that can help you in your endeavour
https://towardsdatascience.com/how-to-reduce-your-power-bi-model-size-by-90-76d7c4377f2d
https://towardsdatascience.com/power-bi-how-to-fit-200-million-rows-in-less-than-1gb-5eee310064b7
Good luck