Forum Discussion
Live dadhboards, refresh rate
Power ParticipantYou need to be more specific because you need to analyze the best aproche :
- What will be the source/database for your data?
- The users will need to see the values updated by secouds? by minutes? by hours?
- Your sistem will generatore how many rows by secound? and by hour?
- The users will need to access historical data? How long ?
BR
Bruno M Costa
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)
- onurbmiguel_
Hello,
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