When trying to refresh data : "There's Not Enough Memory To Complete This Operation"

[Anonymous]

Hi all, 

I have a dashboard on power bi desktop that is based on 12 tables - the largest one is 15 columns and 50.000 rows - and I since a few days I can't refresh the data, it returnrs the "There's Not Enough Memory To Complete This Operation" error. 

I tried to refresh one table at a time, but it doesn't work neither. 

I guess there's some operation during the refresh that takes a lot of memory, but I don't know how to detect which operation costs so much memory. Any ideas? 

Thanks in advance!

Ana 

[v-cherch-msft]

Hi @Anonymous 

If you upload the data in import model, please disable "Allow data preview to download in the background" from options / options and settings/data load.For other cases,please have a look at below posts.

https://community.powerbi.com/t5/Desktop/Not-Enough-Memory-Error/td-p/193818

https://community.powerbi.com/t5/Desktop/Not-enough-memory-for-a-calculated-column/td-p/524244

Regards,

Cherie