Forum Discussion
PC crashes when doing a left join
Ahh okay Merging is not joining. now I understand and for sure its a size issue that you are facing.
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?
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.
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.
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