Forum Discussion
Helper IHelp on memory allocation error in Power BI desktop report
Respected Team,
Seek your guidance on Memory error receieved in powerbi desktop report.
Error message: Memory allocation failure, try simplyfying or reducing the number of queries.
Context: I am extracing data in Power BI report from 400 files folder (45gb) and for which created one sample file and then reapplied the same to the rest files in the folder. After some time (sometime immediate sometimes after couple of hours received memory error). I have connected with my IT folks and increased to 7000 (see below screenshot) but received some error message. Earlier when tries to increased it to 12 GB then my PC restarted. Initially it was on one drive but basis guidance from my IT folks kept the data folder on my local drive which is of 500gb size but still error exists.
Help required: can you please guide me how to work further as this is huge volume of data.
Regards,
Prashant
8 Replies
- amitchandak
Super User
PrashantA , Can you increase virtual memory and check
PrashantA@amitchandak , as mentioned above have tried to increase the virtual memory to 7000/12GB but still received the same error message. I have 16GB RAM in my system and the space available on local drive is 119GB out of 475GB.
- PrashantA
Can anyone guide on the above query
v-kkf-msftCommunity Support
Hi PrashantA ,
In the error message, you may need to increase the amount of memory available on the machine. You can refer to these documents to solve it.https://windowsreport.com/memory-error-allocation-failure/
https://windowsreport.com/increase-dedicated-video-ram-windows-10/
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- PrashantA
Thank you the below has helped but now need your exteded help too. Earlier was working on 400 files of 40gb of one fiscal year and now need to add two more fiscals data so now total will be 130GB.
Do I need to create 3 folders on my local PC drive and then fetch data in powerbi report. Please guide
