Forum Discussion
Schedule refresh not refreshing on time
- Anonymous4 years ago
Hi jpnayak ,
Do you have a lot of measures in your reports that cause complex calculations and take up too much machine memory resulting in incomplete refreshes?
If you optimize them and they do not improve, consider whether it is a memory pressure.Memory pressure can occur when reports require more memory to process and render. Schedule refresh on reports may demand a significant amount of memory on the machine. Especially for larger reports. Memory pressure can result in report failures as well as a potential crash of the report server itself.
If you are encountering memory pressure consistently, it may be worth looking at a scaled out deployment of the report server in order to spread the load of resources. You can also define that a given report server is used for data refresh with the
IsDataModelRefreshServicesetting within rsreportserver.config. With this setting, you could define one or more servers to be the front end server to handle on demand reports, and have another set of servers to only be used for scheduled refresh.For more you can refer to:Troubleshoot scheduled refresh in Power BI Report Server
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous thank you so much for the insight. will consider scaling up the report server if needed.
Scale-up did not help. I had to scale it out to a 2 server deployment. Now one is only used for scheduled refresh. Thank you Anonymous