Forum Discussion
Live dadhboards, refresh rate
So far its just a static dashboard with tables, and charts e.g bar charts, the plan is to update a database and live update the visuals on the dashboard, I am asking to see whether powerBI premium can cover our needs; update every second and understand the limitations if any for live connections 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