Refresh Performance

[BrendenS]

Hello Community,

We have a set of dashboards that run a regular scheduled refresh (every 30min) on a premium capacity workspace.  These reports have consistently ran an average refresh time of 5-10min (based on workspace scheduled refresh Start/End times).  This has been a regular occurrence for over 6 months.  Starting this weekend 7/21 we saw our report refresh times drastically increase from 5-10min to over an hour.  There has been no changes to our data source size/location, workspace capacity, no utilization delay issues, throttling issues, etc.  It seemingly has occurred for the past 24 hours out of nowhere. 

Any ideas what could be causing the increase in refresh time?

Thank you,

Brenden

[Anonymous]

Hi @BrendenS ,

There are many reasons that can affect the performance of the refresh, such as Data Source Performance/Gateway Performance or Resource Allocation，Premium capacity workspaces have dedicated resources, but if other workloads are consuming more resources than usual, it could impact refresh times. Check the capacity metrics to see if there are any unusual spikes in resource usage.
Also you can eview and optimize your queries. Sometimes, small changes in the data or query logic can have a big impact on performance.
Large datasets or complex transformations also can cause memory pressure, leading to longer refresh times. ensure your reports are optimized for memory usage.

Best regards.
Community Support Team_Caitlyn