Forum Discussion

iW1DOV's avatar
iW1DOV
Icon for Helper II rankHelper II
1 year ago
Solved

How 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.  ...
  • ray_aramburo's avatar
    ray_aramburo
    1 year ago

    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á!