Forum Discussion

wmorris20's avatar
wmorris20
Helper II
9 years ago

Connect Live - SSAS - Update Frequency

We have an enterprise data gateway succesfully setup with live connections to SQL Server, SSAS MD, and SSAS Tab.  When viewing the refresh history, it shows that the refreshes are happening roughly every 30 minutes; however, the documentation I have read makes it sound to me like the data should refresh on interaction.  Is there a configuration in the data source or on-premise data gateway that defines that update frequency?  Or is this a configuration that is controlled by Microsoft?

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    wmorris20 Are you referring to the new Service view where it shows the refresh time on the dataset? Or perhaps the dashboard?

    Dashboard tiles should refresh every 15 minutes (this could be the 30 you are seeing)

    I am assuming that the refresh times that show on the dataset are referring to that 15/30 for dashboard tiles because you should have access to the live data if you are actually interacting with the report visuals. I understand that there is more than likely a cache window for visual interaction, but it shouldn't be anywhere near 30 minutes...

    Have you found that the data is actually old compared to what is in your model, or are you just referring to the refresh times as you see them?

    • wmorris20's avatar
      wmorris20
      Helper II
      9 years ago

      Thanks for your response.  I'm good with the Dashboard refresh frequency.  I'm referring to the refresh of the connection to the dataset/model.  I know the model is updated on-premise in my test scenario, because I processed a simple value change.  Once the next update shows in the refresh history, the report that's using the live connection dataset reflects the change.  Thanks for any help you can offer.

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        wmorris20 So when you refresh the model, and you interact with the report in the Service, what is the result? Do you see the new value, or not until this "refresh" happens?

        I would expect that you should see the new value when you interact with your report, regardless of this refresh history.

        I am also assuming that the only reason you see this on a live connection is the cache that supports the dashboard tiles is on this 30 minute schedule...

        If either of the above are not correct, or not what you are seeing, I'm very interested...