I found that there may be a caching issue or something related to the power bi ssas connector and ssas tabular model schema changes. The behavior I observed is that if I make a change to the tabular model (i.e. add new columns, measures, tables, etc.) Then go back to the web UI, it doesn’t show those changes. I tried selecting a different dataset and then going back to the changed dataset and it still doesn’t pick up the changes. I even tried refreshing the browser and closing and restarting the browser and the changes still don’t show. What I ended up doing was going to the server and stopping the ssas connector service and the restarting it and then when I go to the browser and select the dataset I see the changes. I was working through some training with several customers and didn’t have time to wait a long time to see if it eventually shows up (over the course of the things I tried I believe about 8-10 minutes elapsed before I restarted the service) Not sure if anyone has reported this

Bjoern Made another change to the cube to test out, it would appear that browser cache has nothing to do with it. The analysis service connector doesn't seem to send structural updates for hour or so.

Hi, changes to on-prem AS models should get detected every 10 minutes. We tried to repro your scenario and found that the model change was propagated after > 10 minutes as expected. In order to make it show up in the browser, you have to refresh the browser though.There is clearly room for improvement here - from automatically reflecting the change in the browser to an option to trigger a model refresh explicitly. I am forwarding this information to our program management team.If you find the time, we would appreciate it if you could try your scenario again and double-check that you can see the updated model after > 10 minutes and refreshing the browser. Another gotcha I learned about is that you need to re-process the model for the entire AS database; processing the model partially is not good enough. Thanks,Clemens.

Any news on this one? We are struggeling with this for multiple customers. I have experienced it taking up to 10 hours or more even seeing an existing calculated column being added to a new perspective.

I have been having the same problem as is described in this thread and I just waited 20+ minutes after the changes were deployed to the SSAS instance and still do not see the new measure. I have tried just about everything with this. Nothing seams to solve the problem reliably.

Hi,Got very similar problem:After Tabular model was updated - new fields were added to the fact table - change wasn't reflected by the powerbi site. Nothing made it happend - not the service restart, not even SSAS service restart and obviously not the browser restart. 10-15 min waiting period was not able to resolve the problem. Even after several hours of waiting the problem still persisted. Looking on profiler output on the server I noticed that Model refresh tracker query was still pointing to the date of initial service start. The only thing that helped was adding power bi user from the site someone@mycompanyonmicrosoft,com directly to the roles of the tabular db. So effective user was able to refresh the data, but the model itself required the original user. Any idea why? Leonid

Changes to tabular model and the analysis services connector

17 Replies

ckerer
Microsoft Employee
11 years ago
Hi,

changes to on-prem AS models should get detected every 10 minutes. We tried to repro your scenario and found that the model change was propagated after > 10 minutes as expected. In order to make it show up in the browser, you have to refresh the browser though.
There is clearly room for improvement here - from automatically reflecting the change in the browser to an option to trigger a model refresh explicitly. I am forwarding this information to our program management team.
If you find the time, we would appreciate it if you could try your scenario again and double-check that you can see the updated model after > 10 minutes and refreshing the browser. Another gotcha I learned about is that you need to re-process the model for the entire AS database; processing the model partially is not good enough.

Thanks,
Clemens.
- afailor
  Frequent Visitor
  10 years ago
  I have been having the same problem as is described in this thread and I just waited 20+ minutes after the changes were deployed to the SSAS instance and still do not see the new measure.
  
  I have tried just about everything with this. Nothing seams to solve the problem reliably.
- leonido
  New Member
  10 years ago
  Hi,
  Got very similar problem:
  After Tabular model was updated - new fields were added to the fact table - change wasn't reflected by the powerbi site. Nothing made it happend - not the service restart, not even SSAS service restart and obviously not the browser restart. 10-15 min waiting period was not able to resolve the problem. Even after several hours of waiting the problem still persisted. Looking on profiler output on the server I noticed that Model refresh tracker query was still pointing to the date of initial service start. The only thing that helped was adding power bi user from the site someone@mycompanyonmicrosoft,com directly to the roles of the tabular db. So effective user was able to refresh the data, but the model itself required the original user.
  
  Any idea why?
  
  Leonid
  - Anonymous
    Not applicable
    10 years ago
    We have the same problem. I updated the name of a measure in tabular cube. The power BI desktop picked that up straight away however even after 30 minutes the power BI online hasn't. So the Power BI dataset now has fields that are no longer in the cube and hence do not work and yet I can't get it to update. I tried refreshing the report, the browser, processing the cube (Full), restarting Analysis connector. Any suggestions would be highly appreciated. Thanks.
    
    Ankit
hereri
Frequent Visitor
10 years ago
Any news on this one? We are struggeling with this for multiple customers. I have experienced it taking up to 10 hours or more even seeing an existing calculated column being added to a new perspective.
afailor
Frequent Visitor
10 years ago
So, as a last resort, I tried restarting the connector and believe it or not, that connection, and thus all reports associated with it, will not refresh at all. So, if you have a lot of reports on top of the connection, be cautious before going this route.

Still don't know a solid work-around to this, yet.
Tsanka
Kudo Collector
10 years ago
Hi guys,

Has the issue been solved?

Do you know a way to force the Enterprise gateway to refresh the tabular structure?

Thanks
Tsanka
- AaronLS
  Advocate II
  10 years ago
  No it hasn't been solved. I encounter this regularly unfortunately.