Forum Discussion

jpnayak's avatar
jpnayak
Frequent Visitor
4 years ago
Solved

Schedule refresh not refreshing on time

I have 130 scheduled refreshes in my report server, all data refreshes are facing some sort of lag or delay when I check the last run time. while investigating I noticed some new refreshes never star...
  • Anonymous's avatar
    Anonymous
    4 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 IsDataModelRefreshService setting 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 _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.