Scheduled Refresh On, but refresh frequency blank

archi1212 · ‎07-04-2022

I am using Premium per user license and configured a on-premise data gateway for my dataset connecting to a postgresql DB.

My data set scheduled refresh setting is as shown below. The actually, behavior is my dataset refresh every hour after the last refresh time. The problem is that I can't apply such setting to other dataset, which the refresh behavior is what I want to be.

Does anyone know whats the trick to configure such setting?

Pmichel · ‎10-31-2023

Hi @archi1212

Encountered the same issue, then remembered I initially published the dataset in DirectQuery (more options available than only 'Daily/Weekly') and moved it to Import later.

If you set it to 'Hourly' in Direct Query and later move your storage mode from 'DQ' to 'Import' the hourly refresh remains, but you lose the option to change it.

Using Tabular Editor (+ correct licence + correct access rights) you can change the storage mode in the Service.

GilbertQ · ‎07-04-2022

Hi @archi1212

You would have to build some logic into an application which would track the last time it was refreshed and then wait 1 hour and refresh it again.

I would just schedule it to run every hour, which is a lot easier and quicker to configure without having to manage something else.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

archi1212 · ‎07-04-2022

@GilbertQ thanks for your reply. I agree what you said maintaining a hourly refresh is nice and simple.

However, this is the exact behavior how my dataset being refreshed, and I have no idea how it was being configured (the screen I attachde is direct captured from Power BI Service Portal). Perhaps it was a bug, or maybe there are some other tricks to archive such configuration, which is what I want to ask here.

Thanks