Forum Discussion

jimcris's avatar
jimcris
Icon for Microsoft Employee rankMicrosoft Employee
11 years ago

Changes to tabular model and the analysis services connector

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 ...
ckerer's avatar
ckerer
Icon for Microsoft Employee rankMicrosoft 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's avatar
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.