Re: Refreshes from SQL over the Gateway taking lon... - Page 2

motoray · ‎05-29-2025

We have a Power BI Premium Capacity (yep, still thanks to our EA) and I've noticed that over the past year, data refreshes for Power BI reports published to the service are taking an average of 200 seconds longer than they did at the same time last year. I've done some work to try and spread the load out so we don't have so many refreshes happening concurrently, but this still seems like a really big change over the course of one year. Most of our refreshes hit our on-prem SQL datamart, so that means the refreshes use our two-node Power BI gateway setup. The biggest change in refresh times seemed to happen around from September through November 2024, when the average time zoomed up to around 190 seconds. Has anyone else seen anything like this? Has anyone found a solution? Anyone have thoughts as to what might be going on?

motoray · ‎07-14-2025

I did finally put in a ticket today. After digging through logs and watching the behavior for a while, I felt like I had enough data.

The last bit of information I found last week is that it seems to be scheduled refreshes on the hour or half hour that have the biggest issues. I have some instances where I have one report scheduled to do a full refresh at a given time and it takes 10 minutes or longer on the schedule, but less than a minute if I do an on-demand refresh at a different time. This doesn't point to a problem with our reports, but with the service itself.

Also worth noting is that my tenant has not shifted to a Fabric capacity yet as our EA kept us on Power BI Premium.

v-menakakota · ‎07-14-2025

Hi @motoray ,

As you've raised a support ticket, please allow the support team some time to investigate the root cause and provide a solution.

Best Regards,
Community Support Team