Refresh every third working day of the month

[Anonymous]

Hi all, 

I have a dataset whith incremental refresh. I would like to schedule a refresh for every third working day of the month. 

What are my options here? I can use Power Automate, but the scheduling options there are pretty limited too. 

I hope someone in here has some clever way to make this possible. Thanks in advance!

[wikkleyn]

Hi @Anonymous You can make use of the Power BI REST API to refresh your dataset. That gives you the flexibility to refresh the dataset when ever you require and schedule it with an external tool. 

https://www.youtube.com/watch?v=lfP6ygindSU 
https://www.fourmoo.com/2018/06/05/using-the-power-bi-api-with-powershell-scripts-refreshing-your-dataset/ 

[ibarrau · Accepted solution]

Hi. If you can write a code to detect the third working day of the month, then you can do this. You could write a script on cloud (azure functions or azure runbook) or onpremise (local PC). The script can check the date. If it's the third then just send a request to PowerBi Rest API in order to run the refresh of the dataset. You can do that with PowerShell cmdlets or with any other language code with the rest api.

Request of the API: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group

The UI of the tool won't let you configure something like this. You can configure it for everyday if you want or specific days of a week, but not from a month with logic.

I hope that make sense