Refreshing dashboard in browser which uses direct query

[jhorbury]

I have set up a dashboard which uses directquery to connect to a SQL database. The databases is updated every few minutes.

When I publish and view the dashboard, it shows updated data everytime I refresh the browser, or click "refresh" in the toolbar, as I'd expect. However, what I would like to do is trigger this refresh automatically (say, once every minute) so that a user does not have to intereact with it in order to see up-to-date data.

I can use third-party tools like browser refresh extensions, and presumably I could also present the dashboard within an iframe and trigger the refresh using JS in some way - but my quesiton is, is there a way of natively forcing the dashboard to re-load/refresgin using existing options witin PBI?

Thanks for any assistance.

[Sokon]

I agree that this is an important feature. There's this post in the documentation that states for direct and live connections 'Because there is a direct connection between Power BI and the database, there is no need to schedule refresh'. While that's true for a refresh of the dataset, it is NOT true for data shown on screen. There's a 'refresh' button in the report's menu bar for a reason! We need to schedule that refresh.

By this, it would easily be possible to update reports with changing data during the day in an near-real-time manne, without having the necessity to learn how to use Real Time Data in PBI.

If you have the same problem, I suggest voting for this idea!

[Anonymous]

Has anyone found a decent solution to this ? I have been using a 3rd party add-in to rfresh the page but would like something to simulate the refresh button press.