PowerBi Refresh Package in exMon

Created by: Harpa Guðrún Hreinsdóttir

In this article, you will learn how to install a PowerBI 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. Open up PowerBI

In PowerBI

1. Go to your workspace in PowerBI and in the upper right corner select Access. 
   
   
2. Then search for your app registration and click Add.
   
   

3. Next, open up exMon and right-click 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.

   

Harpa is the author of this solution article.