Forum Discussion

henryco88's avatar
henryco88
Icon for Helper II rankHelper II
6 years ago
Solved

Scheduled refresh dataset in Power Bi from Power Automate (Microsoft Flow)

Hi, I have a Power BI project where the data is stored in sql server through Direct Query. I would like to schedule the update of the report and therefore of the data, through Microsoft Automate (Fl...
Need Help
  • Burningsuit's avatar
    Burningsuit
    6 years ago

    HI henryco88 

    That refresh only applies to refreshing Dashboards, if you have a Dashboard created from your Report it caches the data from the Report to avoid continually querying the SQL Database. The best you can do is set it to 15 minutes, then it will regularly query the SQL every 15 minutes and update the Dashboard. Alternativly users can select the three dots on the Dashboard menu and select "Refresh" to refresh the Dashboard. This may be better than the Dashboard querying the SQL Database to refresh itself even if no-one is looking at it every 15 minutes 24 hours a day 7 days a week.  

    Reports do not have this issue as, with Direct Connection, they query the SQL database each time they're opened.  So when you open a Report you always see the up-to-date data. Dashboards work differently, and cache the tile data, so need refreshing.

    You may find that Dashboards are not a good fit with "Direct Query" datasets.

     

    Hope this helps

    Stuart