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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors