Forum Discussion

AmraniO's avatar
AmraniO
Frequent Visitor
9 years ago

Auto update of dashboard

Hello everyone,

 

Probably this question has been asked by several members, but so far, I haven't found any real solution that can fit to the requirement of one of our clients. Let me explain the scenario:

- Datasource used is the SQL Analysis Services on-premises.

- When the user hit the "refresh" button in the report section, he can see always the latest update as it's a live connection which is fine!

- Now, with the dashboard! It's updated every 15 mins as per the documentation of PowerBI. Sometimes the 15 mins can be more or less, so it's not consistent

- For some unknown reasons, the same dashboard for differents machines are not sync. You can see this by adding the "latest refresh time" on dashboard tile. Therefore, the user has to force the update thanks to "Refresh dashboard tile" option.

 

My questions:

1. Is there any way how we can sync all clients to see the same picture of dashboard?

2. Can we "force the update" somehow by using any 3rd party software? 

3. Streaming live data ca be used with SSAS? emmm!

 

Thanks for leting me know your feedback and recommendations!

 

Omar

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    AmraniO

    Can you clarify something for me. What is the need for all machines to be synced at the dashboard level at the exact same time? 

    1. Is there any way how we can sync all clients to see the same picture of dashboard? - Not that I am aware of, though this does pose an interesting question on how the sync occurs. I would think it would be on a tenant level. How different are the refresh times?

    2. Can we "force the update" somehow by using any 3rd party software? - Again, not that I'm aware of.

    3. Streaming live data ca be used with SSAS? emmm! - You can add live streaming into your model, but you could add a live streaming tile to the dashboard from a different dataset.

    • AmraniO's avatar
      AmraniO
      Frequent Visitor

      Thanks Anonymous for reaching out my post.

       

      The reason to have all machines synced is that there are three big screens placed on three different places that are displaying the same dashboard. The dashboard contains some real-time KPIs.

       

      I'm so interested about the 3rd point, do you have any example how I can proceed to make streaming live connected to my SSAS Tabular model?

       

      Kind Regards;

       

      Omar

      • Anonymous's avatar
        Anonymous
        Not applicable

        AmraniO There are a couple threads that describe how to do this, but it is using the report itself, not the dashboard. Mostly because of the limitations that you describe.

         

        If you have the report page showing on the monitors (not the dashboard), there are 3rd party browser plug-ins that can refresh the page. Thus giving you a "real time" look at whatever is in your SSAS model. The side effect of this is that my other recommendation of live streaming tiles would no longer apply :(