Forum Discussion
Live dadhboards, refresh rate
The database will be a postgresql. Yes the users shold see the values updated by second. Hard to tell how many rows by second probably 1. The users will not access the historical data, they will just see the visualizations for a given simulation, e.g an algorithm runs on python when a user choose to run it, automatically data are regirested in the postgresql and then the dashboard should be updated every second of the simulation. (there is no fixed time for how long the simulation will take)
Power ParticipantHello,
My suggestion is that you use a trial veriosn of PPU and explore the DirectQuery in PostgreSQL:
Then on the option "Page refresh" choose as seconds , please read the documentations about that:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
About using DirectQuery please take also a look on this documentation because there are some condition that you need to know:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
As each case is a case, nothing better than try with the data itself
if you do not get the desired results in terms of performance, you will have to consider using a live streaming dataset, but you will have to have another aquetecture between.
Best regards
Bruno Costa | Solution Supplier
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍
Take a look at the blog: PBI Portugal