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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
JoepKamps
Frequent Visitor

Scheduled refresh for multiple reports with same source

Hi all,

 

If I would have multiple online Power BI reports that use the exact same data source (tables from a SQL Server database) and which are scheduled to refresh at the exact same times, does the refreshing of these reports take place in parralel or in series (queued)? In particular, does the refresh of the second report only starts after the refresh of the first report was completely finished (and refreshing the third report only after the second was finished and so forth)?

 

Many thanks!

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @JoepKamps ,

 

First things first, data refresh is based on dataset not report. Second, schedule refresh for different datasets has different refresh processes no matter if the datasets have same source. So the question should be whether two datasets will refresh at the same time.

As far as I know, the datasets will be refreshed one by one randomly, and the gateway will work twice, thought they are set in the same schedule refresh time. 

And 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.

 

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @JoepKamps ,

 

First things first, data refresh is based on dataset not report. Second, schedule refresh for different datasets has different refresh processes no matter if the datasets have same source. So the question should be whether two datasets will refresh at the same time.

As far as I know, the datasets will be refreshed one by one randomly, and the gateway will work twice, thought they are set in the same schedule refresh time. 

And 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.

 

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
AilleryO
Memorable Member
Memorable Member

Hi,

 

It will depends on how you build your reports...

If you create first a dataset, and build all your reports based on this same dataset... All reports will be refreshed simultaneously since it's the dataset that is refreshed (not the report itself, but the report is based on the dataset, so the content of the report is updated).

If you want your report to be refreshed in a specific order (sorting), maybe you should set different automatic refresh and diffrent dataset...

 

Hope this help... Let us know

 

Olivier

Hi Olivier,

 

In my case, these reports do NOT use the same dataset on powerbi.com. They all have their own dataset, though the underlying source is the same. Bottom line: multiple datasets are refreshed at the same time and they depend on the same source. Will this invoke a queue for refreshing these datasets?

 

Thanks!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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