Forum Discussion
Power BI Scheduled Refresh issue
Hey Ganeshwar , We were having the same problem for the past 2 months.
2 things solved this for us.
1- UPDATE the on Prem gateway!
2- When you run the refresh on VM open up task manager and see how much memory it is using. Then Try to optimize the DAX queries so they are more efficent if its using a lot of memory. Not sure what the memory capacity is for Premium
If your model has not changed then the problem is most likely from the gateway not being updated. Or the Dataset is growing and consuming more memory then it did a couple of months ago
Hope this helps
Hi Ganeshwar
I would strongly suggest using Incremental refresh, this uses a lot less memory and also refreshes faster.
When refreshing without incremental refresh it has to refresh the entire dataset, and if you have got calculated columns in your dataset this can increase the memory footprint when refreshing.
Do you get an error when refreshing which you could put in the past.
GilbertQ Thank you for the quick response
We are getting memory time out issue when refreshing which we didnt got in past couple of months
screenshot
Hi Ganeshwar
You would have to look at the Power BI Premium Metrics App to see which datasets are consuming all the memory and see if some datasets can have their sizes reduced?
Also make sure that your current dataset is as small as possible.
If you cannot reduce the size you would then need to get a larger capacity.