Not enough memory to complete this operation

[faustusxanthis]

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. 

[collinq · Accepted solution]

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.