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 Disable/Stop that schedule at all in Power BI?

 

Please find the screenshot below for your reference.

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

  • gtraub's avatar
    gtraub
    Frequent Visitor
    7 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.

  • 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.