Forum Discussion
Refreshing dashboard in browser which uses direct query
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.
2 Replies
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!
