Scheduled refresh is different for all my datasets

[icbd]

Good morning everyone,

I have a question regarding the scheduled refresh for my datasets. I currently us an on-premise gateway linked to three different SQL servers.

In the scheduled refresh page, the first dataset shows this and that one refreshes hourly:

The second shows this, and also refreshes hourly:

And the last one, I cannot seem to select hourly or have it refresh hourly, so I have it setup like this at the moment:

Would anyone know why this particular dataset cannot be refreshed hourly, are there limitations that I am not aware of preventing me from having the option?

Thanks in advance.

[v-yangliu-msft]

Hi  @icbd ,

The third data set is Import connection mode, Import data from the original data source into the dataset according to the refresh schedule or on demand.

You can choose whether it is Daily or Week, select your time zone, and then select the refresh time.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#data-refresh

https://www.c-sharpcorner.com/article/what-is-data-refresh-in-power-bi-and-how-to-set-up-schedule-re...

The first and second data sets are Direct/LiveConnection connection mode, a tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results, you can change the schedule in the dataset settings.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#datasets-in-directqueryliveconne...

Best Regards,

Liu Yang

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

[icbd]

Further proof of the first two datasets refreshing hourly while the last one does not: