Forum Discussion
Not enough memory to complete this operation
Good day!
I am trying to create a dashboard that's supposed to consolidate and load at least 52 Excel files averaging 55MB each. However, the dashboard contains a bunch of measures and calculations. After a while, after refreshing, I encounter the error "There's not enough memory to complete this operation. Please try again later when there may be more memory available".
Here are my machine's technical specifications:
RAM: 12GB
Hard Drive: 128GB free out of 199GB
Error Log Diagnostics:
Peak Virtual Memory: 71.1 GB
Private Memory: 849 MB
Peak Working Set: 1.1 GB
What could be the problem? Do I need to increase the RAM or the Virtual Memory? I can't decrease the calculations and measures. We are also not allowed to use DirectQuery.
Hi faustusxanthis ,
I would think that you should increase the RAM to 32 or maybe 36 GB and try again. The error message indicates that you are running out of memory and I know that the official Microsoft recommendations are lower but more physical RAM is always the best bet.
1 Reply
Hi faustusxanthis ,
I would think that you should increase the RAM to 32 or maybe 36 GB and try again. The error message indicates that you are running out of memory and I know that the official Microsoft recommendations are lower but more physical RAM is always the best bet.