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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
tannhq
Helper I
Helper I

Schedule take much longer than on demand

I created dataset from Power BI Dataflow, I don't know why schedule takes longer than on demand.

 

tannhq_0-1658112701243.png

 

1 ACCEPTED SOLUTION
Burningsuit
Resident Rockstar
Resident Rockstar

Hi @tannhq 

This is because scheduled refreshes are put into a queue, whilst manual refreshes are run immediately.

Sheduling refreshes puts them on a queue to refresh, along with all other refreshes in the Power BI service you have a licence for. "On Demand" refreshes are at the head of this queue and are run sooner than scheduled refreshes. If you have a Free or Pro licence the scheduled refresh may be in a queue for up to 2 hours before timing out.

So the time you schedule refresh is the time it is put into the queue, which may include a wait until resources become available.

You can reduce to remove this wait by putting the content into a Premium Per User workspace, which has more resource capacity, or a Premium Capacity workspace, where you manage your own compute capacity to ensure each refresh gets the resources it needs.

see Data refresh in Power BI - Power BI | Microsoft Docs

Hope this helps

Stuart

View solution in original post

1 REPLY 1
Burningsuit
Resident Rockstar
Resident Rockstar

Hi @tannhq 

This is because scheduled refreshes are put into a queue, whilst manual refreshes are run immediately.

Sheduling refreshes puts them on a queue to refresh, along with all other refreshes in the Power BI service you have a licence for. "On Demand" refreshes are at the head of this queue and are run sooner than scheduled refreshes. If you have a Free or Pro licence the scheduled refresh may be in a queue for up to 2 hours before timing out.

So the time you schedule refresh is the time it is put into the queue, which may include a wait until resources become available.

You can reduce to remove this wait by putting the content into a Premium Per User workspace, which has more resource capacity, or a Premium Capacity workspace, where you manage your own compute capacity to ensure each refresh gets the resources it needs.

see Data refresh in Power BI - Power BI | Microsoft Docs

Hope this helps

Stuart

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.