How to Set Dataset refresh Monthly

Hi mshao  You would not be able to set monthly refresh data set except daily and weekly in power bi service. But you can achieve this using power automate.

If you interested, then you can follow the steps below:

1. Go to Power Automate and sign in with your Microsoft account. See image below:

2. Click on “Create” and select “Scheduled cloud flow.” See image below:

3. Configure the flow to run on the first day of every month. You can set the exact time you want the refresh to occur.

4. Click on “New step” + button and search for “Power BI.” See image below:

5. Select “Refresh a dataset” from the list of actions. See image below:

6. Choose your workspace and dataset that you want to refresh from left pane. See Image:

7. Save the flow and test it, and you are done.

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz