Forum Discussion

georgepaph12's avatar
georgepaph12
Frequent Visitor
3 years ago

Live dadhboards, refresh rate

Hello everyone,   I would like to ask a question regarding the refresh rate of live dashboards. I recently discovered that with premium capacity, it is possible to have up to 48 refreshes per da...
Need Help
georgepaph12's avatar
georgepaph12
Frequent Visitor
3 years ago

Its a database that updates every second, so I guess live streaming dataset

onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
3 years ago

Hello 

 

Can you please share a image of this workspace so i can understand what you have build. 

If possible in the lineage view: 

 

thanks

 

 

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 

 

 

  • georgepaph12's avatar
    georgepaph12
    Frequent Visitor
    3 years ago

    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.

    • onurbmiguel_'s avatar
      onurbmiguel_
      Icon for Power Participant rankPower Participant
      3 years ago

      You 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

       

      • georgepaph12's avatar
        georgepaph12
        Frequent Visitor
        3 years ago

        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)