On-demand report refresh overlaps the scheduled refresh setup

[NKV]

Hey guys, I hit something, but I don't know it expected or not.

I have a report uploaded to the power bi service, and there is an active schedule refresh setup. In my case, the report is scheduled for 10:30 and works perfectly. But there is a case when I need to refresh the report manually (on-demand) before this time. And what is happening that the on-demand refresh overlap the scheduled refresh, and in the end, I have the same report refreshing two times in the same moment, which increases the refresh time.I can turn off the scheduled refreshes, but I don't want because I will forget then to turn it on.

Do you know is it expected behaviour or smells like a bug?

[v-luwang-msft]

Hi @NKV ,

According to the description on the official website:

Having configured a refresh schedule, the dataset settings page informs you about the next refresh time, as in the screenshot above. If you want to refresh the data sooner, such as to test your gateway and data source configuration, perform an on-demand refresh by using the Refresh Now option in the dataset menu in the nav pane. On-demand refreshes don't affect the next scheduled refresh time.

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.

Power BI deactivates your refresh schedule after four consecutive failures or when the service detects an unrecoverable error that requires a configuration update, such as invalid or expired credentials. It is not possible to change the consecutive failures threshold.

Wish it is helpful for you!

Best Regards

Lucien

[NKV]

Hey hi,
I hit this issue when there is the active setup of a scheduled refresh, and I hit refresh now.

For example:

There is a scheduled report refresh for 10:30, and at 10:00h, I hit refresh now. The refresh takes more than 30min  and then at 10:30, the scheduled report starts, and I hit the case with the overlapping report refreshes.

[arvindsingh802]

Yes this seems a bug, to cancel the refresh please follow Analyze active sessions and cancel refreshes in Power BI – Data – Marc (data-marc.com)

If this post helps, then please consider Accept it as the solution and give it a thumbs up.