Forum Discussion
Memory error when refreshing
Hi all,
Since a few weeks I'm having problems refreshing my data in PowerBI desktop:
I'm running a 64-bit version with 16GB memory. Task manager shows msmdsrv.exe causing spikes for a few seconds, then I get the error. This is only after the data in the tables has been loaded.
The .pbix file is about 380 mb and the model is a little complex, but not much has changed in the last months yet I can't seem to refresh at all in the past weeks.
Did anyone experience the same problem and/or have a solution for this?
9 Replies
What is your data source? If you are using Import mode, maybe you can try with DirectQuery mode.
Best Regards,
Herbert
Thanks for your help. Cannot get back into my tablet just now may try my laptop. Could not start the course until Friday as had error problems. Sorted them but now it is memory problems.
I will take your advice once I am up and running again. Thank you.
v-haibl-msft wrote:What is your data source? If you are using Import mode, maybe you can try with DirectQuery mode.
Best Regards,
Herbert
Thank you I will.
I would suggest ensuring that you only include the columns that you require.
Also possibly some of the data has a high level of cardionality, which is causing the data not to compress as efficiently as it should?
Another tip is if you are doing any calculated columns in the Power BI Model, to move the ones that you can into the Query Editor. The reason for this is that due to the columns being computed before the xVelocity engine completes it's tasks, this will cause the columns to be more efficiently compressed. Which in turn could save you memory.
Thank you for your replies.
ankitpatira I doubled the cache size after you suggested it, this didn't seem to work at first but the refresh completed today and yesterday so maybe it had something to do with it after all. I'll accept this as the answer for now.
v-haibl-msft I use a lot of different sources, DirectQuery is not an option anymore.
GilbertQ I'll look into making the model more efficient. I exclude unneccessary data/columns as much as possible but I do have a lot of calculated columns/measures so maybe that's why completing the refresh was so difficult.
Hi Anonymous
It does appear that you have hit the 32bit memory limit. As suggested before possibly see if you can reduce the columns to enable for it to fit into the memory allocation for 32bit.
