Schedule to refresh Power BI Dataset using Windows Task Scheduler

In my previous post “Refresh Power BI Data using SSIS custom component” I used SSIS component to refresh dataset in Power BI service.

Here is another way to refresh Dataset in Power BI.In this example a free desktop application is used to refresh dataset in Power BI service. The application can be run as command line or scheduled using Windows Task Scheduler.

Steps

Install Desktop App.

Click here to Download and Install Power BI Helper application (PBIHelper)

NOTE: The application connects to Power BI service via API. In general, to use Power BI APIs, we need to register the application with Power BI service. The application also needs to be authorized by Azure. This is one time process.

        The post App registration for Power BI API use via Azure Portal explains required steps in detail. The SSIS component requires Client ID from App registration (as Native App) process.

Schedule to refresh dataset in Power BI using Windows Task Scheduler

Action: Choose “Start a program”

1. Program/action:

Select PBIHelper application from installed location.

For example: C:\Program Files (x86)\Inservit\PBIHelper\PBIHelper.exe

2. Add arguments (optional):

Arguments – Refresh Dataset in a group:

If you have created profile and/or logged on to Power BI Helper application at least once:(recommended secure method)

“Request=Refresh;PBIUsername=<Power BI User ID>;Group=<Group>Dataset=<Dataset to Refresh>”

          Example: “Request=Refresh;PBIUsername=xyz@abc.com;Dataset=Sales”

If you have not created profile with Power BI Helper application:

“Request=Refresh;PBIUsername=<Power BI Username>;PBIPass=<Power BI Password>;ClientID=<Client ID>;Group=<Group>;Dataset=  <Dataset to refresh>”

Example: “Request=Refresh;PBIUsername=xyz@abc.com;PBIPass=****;ClientID=0000-0000;Group=GlobalSales;Dataset=Sales”

Arguments – Refresh Dataset in My Workspace

If you have created profile and/or logged on to Power BI Helper application at least once:(recommended secure method)

“Request=Refresh;PBIUsername=<Power BI User ID>;Dataset=<Dataset to Refresh>”
Example: “Request=Refresh;PBIUsername=xyz@abc.com;Dataset=Sales”

If you have not created profile with Power BI Helper application:
“Request=Refresh;PBIUsername=<Power BI Username>;PBIPass=<Power BI Password>;ClientID=<Client ID>;Dataset=  <Dataset to refresh>”

Example: “Request=Refresh;PBIUsername=xyz@abc.com;PBIPass=****;ClientID=0000-0000;Dataset=Sales”

3. Start in (optional):

Enter Power BI helper installation folder.

Example:  C:\Program Files (x86)\Inservit\PBIHelper

Schedule to refresh Power BI Dataset

About the Author

Leave a Reply

Your email address will not be published. Required fields are marked *