Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Disable Scheduled Cache Refresh

Hi Team, I want to disable Scheduled Cache Refresh which gets setup by default when there is a report thriugh direct query.   I can see the option to configure it to daily/weekly, but can we Disab...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous,

     

    Nope, it is impossible to disable scheduled refresh on live connections(direct query, live connection).

    For your requirement, I'd like to suggest your use import mode to instead.

     

    Regards,

    Xiaoxin Sheng

gtraub's avatar
gtraub
Frequent Visitor
6 years ago

This is a big problem, as the cache refresh in our case can use a lot of CPU. Another issue is that it something causes the dataset to revert back to an hourly refresh. I thought it was when a user publishs a report but i tested and thats not the case so not sure what triggers it yet. This is a big issue as it is causing our servers to max out cpu.

 

Changing the queries to import mode is not always and option as the data sets might be to large for import and you lose the business logic that SSAS provides as well as adding addtional data modeling to this method.