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 e...
wmorris20's avatar
wmorris20
Helper II
9 years ago

I added a slicer to the report thinking that it had to be a literal interaction and not just refreshing the page/report, but that didn't work either.  Here are some examples using the Adventure Works data and manipulating sales amount:

 

Power BI Online:

 

 

 

 

 

 

On-Premise Version (Desktop):

 

 

 

 

Power BI Online after Refresh History shows update:

 

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

wmorris20 I read your question in this way: You are updating the SSAS model and when you then interact with the report in the Service (Use slicer, interact with visuals for filtering purposes) the updated information is not showing. -> If this is the case, this is a bug and you should submit this as an issue.

I've confirmed with the team that this should interaction should show the latest information, and the caching process that you see in the history shouldn't be the only time the data is refreshing.

  • wmorris20's avatar
    wmorris20
    Helper II
    9 years ago

    Correct, I have a confirmed updated model (via Power BI Desktop); however, the online version via data gateway is not showing updated data until the (~30 min) refresh happens.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      wmorris20 That is a bug. It should be showing you the updated data as you interact with it.