Forum Discussion
Power BI Report Server Refresh schedule not syncing the data in a scale out environment
The behavior is expected, due to caching. Server-B will only pick up an updated model after (1) Server-A's refresh has completed and it has committed the model back to the shared report server catalog database and (2) A new session is created on Server-B.
Sessions are per server, per user and a timeout. Sessions are extended by the client browser when in use. So, in this case you can decrease the session timeout. The performance risk would be, if there are other users on that server that open and view reports & leave it idle past the session timeout... then they'll need to take the latency hit to reload the model.
Thank you Jon for the update. So inorder to get the most updated data to the user I need to reduce "SessionTimeout" property from its default value 600s to some where less than 300s (less than 5 mins). I'm also wondering how are "ModelExpirationMinutes" and "ModelCleanupCycleMinutes" have effect on this process.
I usually lower "ModelExpirationMinutes" and "ModelCleanupCycleMinutes" to 15 mintes from default 60 minutes for scale-out deployment. There is no clear guide line from Microsoft regarding this.
