Dataverse dataflow automatic refresh on weekdays only

[mayarnaldo15]

Hi,

I am trying to ask google this unfortunately, I didn't find any information.

Is there any way that the dataflow can only refresh during weekdays only?

Any help is appreciated! Thank you.

Regards,

M

[dpoggemann · Accepted solution]

Hi @mayarnaldo15 ,

The scheduling options for dataflows does not provide this by default (https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-and-use-dataflows#set-the-re...).  

One option to handle this is to setup a Power Automate Flow on a schedule (which can be more advanced) and have it trigger your dataflow refresh.  

Power Automate Flow Scheduling (Advanced Options):  https://learn.microsoft.com/en-us/azure/connectors/connectors-native-recurrence?tabs=consumption 

Video showing how to kickoff a Dataflow from Power Automate Flow:  

https://youtu.be/orA14T5iFEE