PowerBI monthly report refresh

How to setup monthly refresh for PowerBI ?

PowerBI generally allows daily or weekly refreshes with options of selecting multiple time values. But if we want to refresh it once in a month then we have two options.

• Using PowerBI API and ADF
• Using Logic Apps and ADF

For both options we need to have a powerbi user. For API we can use the app based authentication as well and then we can call the dataset refresh api. 

Option 1 API 

In this option we need to use ADF web activity where in first web activity we will need to get tokens which can be used to call the dataset refresh api method. Once we are good and pipeline wiorks well then we can go ahead and create a monthly schedule trigger.

Option 2 

Here we will need a valid power bi user and logic app. We go to the logic app authoring page and set heep request action and then next step will be powerbi dataset refresh. This will require a powerbi connection to be created from logic app. The method will need the dataset id which we can obtain by going to powerbi.com. Next step is same as previous i.e create an ADF pipeline with one web activity which will call the logic app using http request. Now create ADF pipeline monthly schedule trigger.