Forum Discussion

ramankr48's avatar
ramankr48
Helper II
1 year ago
Solved

Real Time Intelligence - Dashboard Refresh Rate

Hi everyone, I have a question regarding the refresh behavior of real-time dashboards in Fabric.

 

I'm currently using the trial capacity (F64), and in the real-time dashboard settings, under the auto-refresh option, there's a mode labeled "continuous."

Q. I'm curious — is there a fixed refresh interval happening in the background (e.g., every 1 second), or does the dashboard update purely based on when new data arrives?

 

Q. Additionally, are there any other ways — within Real-Time Intelligence or Power BI — to configure dashboards to refresh multiple times per second?

 

I'm open to any suggestions. Our requirement is to implement a solution (using Power BI, Fabric, or any other suitable tool/tech) where dashboard visuals can update several times per second, if possible.

 

Thanks in advance for your insights!

  • Hi @ramankr48 ,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.


    Regards,

    Chaithanya.

6 Replies

  • Hello ramankr48 

    The Real-Time Dashboard uses a pull/polling mechanism to read data from the KQL Database table(s).

     

    Keep in mind that there can be a delay between the arrival of the data in the database and the actual representation of those points in the dashboard. 

     

    The dashboard update is done time-after-time when set to Continuous (a spinning wheel is shown as an indication of each update).

     

    At this time, Eventhouse (and the underlying Azure Data Explorer) do not support CDC and Dashboarding tools in general use polling.

     

    I'm not familiar with the PowerBI (which pulls data on refresh when using Direct Query for KQL queries) settings regarding the minimal update frequency, but it will not be as fast as the Real-Time Dashboard.

     

    Check out Managed Grafana as an alternative which is popular for Engineer and Operator personas.

      

  • v-kathullac's avatar
    v-kathullac
    Community Support

    Hi ramankr48,

     

    Thank you for reaching out to Microsoft Fabric Community Forum.

     

    The Real-Time Dashboard uses a pull/polling mechanism to read data from the KQL Database table(s).

    1)Is there a fixed refresh interval (e.g., every 1 sec) in "Continuous" mode?

    Power BI dashboards don’t refresh on a fixed timer. Instead, they update when new data comes in.
    For streaming data, visuals (like line charts or KPIs) can update almost instantly.
    However, Power BI adds a slight delay (like once per second) to avoid overloading the screen.
    If you're using DirectQuery with real-time sources (like KQL or ADX), visuals only update when the page is refreshed or auto-refresh is turned on.
    So, while updates happen when new data arrives, Power BI controls how often the visuals refresh to keep things running smoothly.

     

    2)Additionally, are there any other ways — within Real-Time Intelligence or Power BI — to configure dashboards to refresh multiple times per second?

    Power BI visuals don’t refresh more than once per second — this is to protect performance.
    However, you can still create near real-time dashboards by:
    1)Using streaming or push datasets that update when new data arrives
    2)Enabling auto-page refresh (as fast as 1 second in Premium)
    3)Choosing simple visuals like KPIs or line charts that refresh quickly

     

    Attaching the Autopage refresh blog for reference:
    https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh?utm_source=chatgpt.com

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

     

    Regards

    Chaithanya.

    • ramankr48's avatar
      ramankr48
      Helper II

      solution you suggested, i have alrady implemented it, anyway thanks for info

       

      with the eventstream i want to load the data into the lakehouse, then will import the data into powerbi desktop from lakehouse, so here how frequently are we able to refresh the data into powerbi
      or can you suggest any other way

      • v-kathullac's avatar
        v-kathullac
        Community Support

        Hi ramankr48,

        Below are the few information related to refresh fequency.

         

        Power BI Desktop – Data Refresh from Lakehouse :

        1 )When you import data from a Lakehouse (via OneLake in Fabric), you're doing an import mode connection in Power BI Desktop. This means:
        2) The data in Power BI is static until you manually refresh it.
        3) In Power BI Desktop, there’s no automatic refresh—you have to click "Refresh" to pull updated data from the Lakehouse.
        4) If you publish the report to the Power BI Service, then you can schedule refreshes.

         

        Refresh Frequency in Power BI Service (after publishing)
        1) If you're using Power BI Pro You can schedule up to 8 refreshes per day.
        2) If you're using Power BI Premium (Per User or Capacity):
        3) You can schedule up to 48 refreshes per day (i.e., every 30 minutes).
        4) So once your data is in the Lakehouse, you can set Power BI to fetch it at the frequency your license allows

         

        Attaching the microsoft blog for reference : https://learn.microsoft.com/en-us/fabric/fundamentals/lakehouse-power-bi-reporting 

         

        Regards,

        Chaithanya.

  • v-kathullac's avatar
    v-kathullac
    Community Support

    Hi ramankr48 ,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.


    Regards,

    Chaithanya.

  • v-kathullac's avatar
    v-kathullac
    Community Support

    Hi @ramankr48 ,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.


    Regards,

    Chaithanya.