Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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!
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.
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |