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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors