How to schedule refresh of report on first of every month

[Anonymous]

Hi Community Members,

I would like to schedule a report to refresh only on first of every month . Currently, i do not see any option . Is there a way to automate the refresh using Microsoft Flow or Power Automate ? 

Please suggest some methods to do so . 

G Venkatesh 

[ibarrau]

Hi. Yes you are right. If you want the refresh the first of the month you have two alternatives.

1- Running an custom API call with your own code from a VM or Azure script.

2- Creating an automate flow running monthly starting the first day of the next month.

Hope this helps,

Regards

[Anonymous]

Hi, 

Thanks for the reply. However, i will have to rule out the first option as we do not have required set up ( Azure subscription or vm) . 

I can use second option . However, i forgot to mention before that we have to trigger data flow instead of dataset. is is still a possibility ? 

G Venkatesh

[V-lianl-msft]

Hi @Anonymous ,

You can refer to this:https://powerfulbi.co.uk/blog/f/powerbi-status-with-powerautomate-refresh-all-in-one-powerapp-1 

Here is a corresponding feature request, please click to vote it up.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

I'm sorry but dataflows is not available in Power Automate yet. If you want to refresh that you can check if you can do it by API. About the azure subscription an automation account or azure function is really cheap. You have 500 minutes free when creating the account for automation and then you pay cents for the processing. That's the best option without a VM.

You can always schedule refresh the power bi everyday even if the data is the same and the 1st of the month will be refreshed.

Regards,