Forum Discussion
Helper IIHow to setup automatic refresh for report connected live to PBI dataset?
HI all,
I have been requested to continuously display a report page on an independent display in the CEO office (urk!). The page should automatically refresh itself every - say - 15 minutes.
According to this article https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh there should be an appropriate setting to do this; however I have no "refresh" settings in PBI Desktop:
The report is connected live to a PBI dataset in a Premium Capacity (F64) workspace
And according to the article mentioned above this is a supported scenario to configure automatic refresh:
What am I missing? If this feature isn't available anymore, is there any other way to achieve the desired result?
Thanks in advance,
Gianfranco
Understood! And agree, if that's what asked from leadership we shall comply! What's happening is that that Page refresh setting appears only with explicit Direct Query connections (Anybody would assume it's the same as the Live connection) and Power BI treats different a live connection. What you need to do is change the storage mode to Direct Query:
Click on Make changes to this model, then Add a local model:
Leave everything checked and then click Submit
Wait for the changes to be applied and voilá!
