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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jcapezzuto
Resolver I
Resolver I

Scheduled Refresh timeout

Over the past week, we've been encountering issues with the scheduled refresh of a dataset.  This dataset refreshes in under 5 minutes manually, but when the refresh is scheduled it takes over 2 hours and then times out.  This is happening in a standard workspace (not premium).  Has there been a planned reduction in the capacity for standard workspaces?

4 REPLIES 4
v-xicai
Community Support
Community Support

Hi @jcapezzuto ,

 

From the Microsoft Official document https://docs.microsoft.com/en-us/power-bi/refresh-data#setting-a-refresh-schedule , we know:

 

>>Note also that the configured refresh time might not be the exact time when Power BI starts the next scheduled process. Power BI starts scheduled refreshes on a best effort basis. The target is to initiate the refresh within 15 minutes of the scheduled time slot, but a delay of up to one hour can occur if the service can't allocate the required resources sooner.

 

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support to get further help.

 

Best Regards,

Amy

 

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

 

Thank you, Amy, but that is not the problem.  I can see the actual start times by viewing the refresh history, and they are only a few minutes off from the scheduled start time.  Even considering this the overall duration is still much longer than running the same refresh manually from within the service.

 

Last night, the scheduled refresh completed normally in 15 minutes.  I'm curious to know if other users are seeing the same inconsistent behavior before I open a support ticket.

 

 

We are on the shared service (not Premium) as well and I've been seeing random failures for weeks. This morning while trying to recover from a weekend power outage that caused failures on my end, an on-demand refresh has taken more than two hours and still isn't done. I'm guessing it's because of this: https://www.screencast.com/t/MeiS3ZeYKc6y Frustrating for sure, regardless of the reason.

Scheduled refresh worked well last night.  Hopefully the problem has been resolved.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors