Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

0

Refresh Performance

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?

 

BrendenS_0-1721680863522.png

Thank you,

Brenden

Status: Delivered

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

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