Microsoft has announced an exciting new feature for dataset owners in the Power BI service — Scheduled Cache Refresh.
With this feature in place, dataset owners now have full control over the cache refresh cadence of their DirectQuery and live connection datasets. This will make sure you always have most up-to-date dashboard visuals or alternatively you can lower the load on your underlying data source by lowering the cache update cadence.
If you’ve already set up a dataset with DirectQuery or live connection in the Power BI Service, please note:
With this update, we are setting the scheduled cache refresh cadence of all existing DirectQuery and live connection datasets to be one hour. When this feature rolls out in your region, we will send you an in-product notification if you are the owner of any such datasets.
How to change the scheduled cache refresh cadence of your DirectQuery/live connection datasets
- Navigate to dataset settings.
2. In settings, go to the dataset tab, and then navigate to the dataset whose scheduled cache refresh cadence you’d like to change. Below, we’ve selected a dataset that which connects to Azure SQL via DirectQuery.
3. Next, expand the section titled Scheduled cache refresh. This is the section added by this feature. It will be available on all DirectQuery/live connection datasets, regardless of the data source.
4. You can use the dropdown to adjust the cadence. You may configure scheduled cache refresh to occur as often as once every 15 minutes, or as rarely as once a week. Once you are satisfied with your selection, select the Apply button to confirm the new cadence.
And that’s it! Later, you can check the Refresh history button in dataset settings to confirm that your scheduled cache refreshes with the new cadence.