Disable Scheduled Cache Refresh

[srlabhe123]

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.

[gtraub]

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]

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.

[v-shex-msft · Accepted solution]

Hi @srlabhe123,

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]

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.