Forum Discussion
Not Enough Memory available
I have a file of 1.2 GB, with >20 millions lines, when it's refresh the error message is not enough memory available, try again later.
8 Replies
- bcdobbsCommunity Champion
Are you getting the error refreshing on your local machine or in the service?
There's some useful tips in https://apexinsights.net/blog/top-5-tips-to-optimise-data-model
- owongisazaFrequent Visitor
It's in my computer. the data I'm using is coming from Sharepoint folder.
- bcdobbsCommunity Champion
How much RAM does your local machine have.
If you go into power bi desktop settings >> global >> data load you can try and increase the value there however not convinced it will fix the issue.
- owongisazaFrequent Visitor
My laptop has 16GB, I increased the size but still giving me the same error.
- bcdobbsCommunity Champion
I just came across this which you might find useful:
https://towardsdatascience.com/how-to-reduce-your-power-bi-model-size-by-90-76d7c4377f2d
- Pascal_KTeamResolver I
Try to clear cache before refreshing the data
- v-kkf-msftCommunity Support
Hi owongisaza ,
Please see if these documents are helpful:
FIX: Power BI Memory error allocation failure
Speed Up Power Query In Power BI Desktop By Allocating More Memory To Evaluation Containers
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - v-kkf-msftCommunity Support
Hi owongisaza ,
Has your problem been solved? If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz