Forum Discussion

archi1212's avatar
archi1212
Frequent Visitor
4 years ago

Scheduled Refresh On, but refresh frequency blank

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, ...
Tips and Tricks
Pmichel's avatar
Pmichel
Frequent Visitor
2 years ago

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.