Disabling an automatic dataflow refresh for specified duration

[Giorgi1989]

Dear All,

I have a need to disable automatic refresh of my dataflow for the first 10 days of each month (after that to be updated daily). 

Since we only have daily/weekly refresh frequencies, is there any easy way of disabling automatic refresh for any desired period? 

Or manual refresh would be my only choice?

Thank you! 

[v-luwang-msft]

Hi @Giorgi1989 ,

In my opinion, this cannot be done, the design makes it so that your refresh can be based on days and weeks, but cannot be set to a specified number of days in a specified month.

Refer:

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data#live-connections-and-directquer... 

Best Regards

Lucien

[Giorgi1989]

Thanks Lucien. That is my understanding as well. I just wondered whether anyone might be in possession of knowledge of some sort of workaround. 🙂 

[vanessafvg]

if you have access to something like devops you can probably run your own schedules via powershell but as far as i know not using the default scheduler in power bi service itself, no.

https://craigporteous.com/how-to-refresh-power-bi-dataflows-with-powershell/

https://ssbipolar.com/2020/08/12/power-bi-dataflows-powershell-scripts-on-github/