Power BI Refresh Package in TimeXtender Orchestration

In this article, you will learn how to install a Power BI refresh package. To be able to do this, in the Azure Portal, you need to create an App registration which you will use to access our Power BI. This is done under the Azure Portal > Azure Active Directory > App Registration

Create an App registration

1. Open up the Azure Portal here

2. Search 'App Registration'

   

   

3. For this example, name the application 'Test' and click Register at the bottom of the page

   

4. Click on Certificates & secrets

   

5. Then, click on New client secret

6. Add a description of your client secret

   

7. Specify when this key should expire. Then click Add
8. On the next page, copy your secret value

   

9. Add the following permissions

   

10. Enable the “Service principals can use Fabric APIs” setting under Tenant settings in the Admin Fabric portal

    

     

11. Open up Power BI

In Power BI

1. Go to your workspace in Power BI and in the upper right corner select Access. 

   

2. Then search for your app registration and click Add.

   

3. Next, open up TimeXtender Orchestration and right-click Orchestration > Packages, select New > Power Bi Refresh, and then select a name for the Power Bi Refresh package.

   

4. Select an Execution connection and fill in the tenant-id, app-id, client secret and the group-id and then click login, this should populate the rest of the fields.

   • In Azure, open the app registration and in the overview, you can find the app-id (1) and the tenant-id (2)

     

   • Now head to Power Bi and find out your Power BI dataset's group-id.

   • In the left menu find your dataset, hover over it and click the three dots and select Settings.

     

   • The URL should look like this and you can copy the group-id (1)

   

5. Select a subscription and dataset.

6. Then when you are happy with the information in the fields you can click the save icon in the top left corner and run the Power BI Refresh package.