Turn on a Power BI Refresh at the end of the month

(0) Share

Report

Posted on by DemoFour

Hi all,

I have jumped across from the Power BI Forum, as I wanted to get some advice as I am new to building flows.

Objective: I want to turn on my schedule refresh in Power BI to run more frequently at the end of the month, as business users enter, there monthly stats.

The rest of the month, it only needs to be a daily refresh, but in the last week of the month, I need to see the data coming in each day with hourly refreshes.

When I set my refresh up in my PBI workspace I can choose daily or set times, but I don't need to have it refreshing like this all month, so I would rather have a better approach and not have to manually change this once a month.

Question: Can I use Power Automate to run a more frequent refresh time?

Any pointer to flows or functions to do this would be much appreciated, in the meantime I will have a look at the resources in the flow UI.

Thank you in advance for any help.