Memory issue when refreshing the report

[unnipbi123]

Hello All,

I have 3 power bi reports which has a size of 120 MB each. the refresh was working fine since 2 years. but all of a sudden since 3 days, i was getting the below error when refreshing the reports.

i tried disabling auto date/time from option and settings. however getting the same error. i am using 16 gb RAM and i tried cleaning up some space on my local drives as well but still same. Please help

[Saap · Accepted solution]

Hi @unnipbi123 

1. Try to limit the amount of data you're pulling from the source,
2. Delete columns you don't use,
3. If you use calculated columns, try to count them in Power Query,
4. If you do transformations in Power Query, check if you can do them in data source (query folding)

[amitchandak]

@unnipbi123 , Please try to increase the memory management cache to 8-10 GB. Also, increase the virtual RAM of your system

check these setting too

[unnipbi123]

@amitchandak i tried all the options mentioned above still having the same issue. will it be an issue of O365 server that is running the power bi?Please help