Create a PowerBI embedded view in exMon

Created by: Kristinn Magnusson

In this article, you will learn how to create a PowerBI embedded view in exMon. PowerBI can be embedded into the exMon DM Web interface so a user can type in changes to a table and visualize the changes on the same screen. In Order to set up a PowerBI interface, you can right-click in the menu tree and click Add New PowerBI Report.



 

First steps

Next, you publish a report to PowerBI and set the following attributes:


PowerBI Configuration

  • Client GUID - This is an Application GUID which can be obtained through the Application Registration process, see further down in this article under Register exMonDM inside PowerBI
  • Group GUID - This is the Group Folder GUID where the PowerBI report resides.
  • Report GUID - This is the GUID of the Report to be embedded into exMon DM.
  • Username - Username for the PowerBI tenant (user@domain)
  • Password - Password for the Username

exMonDM Table Configuration

  • Select the Table to embed it in the view.

Docked Configuration

  • Choose the location of the embedded exMon Table and set Size to heigh in pixels, i.e. 300.


Click Save and Open in Browser, your PowerBI Embedded view should now open in a browser in exMon DM Web.


Register exMonDM Application for PowerBI

Go to https://dev.powerbi.com/apps

Note: For further information about App registration see Microsoft documentation, here


  1. Sign-In with your Office 365 credentials
  2. Fill out the registration form as follows 
    1. Application Name - exMon DM Web
    2. Application Type - Native
    3. API Access - Select All
  3. Click Register and you should see the following dialog
  4. Copy Application ID and paste it as Client GUID in the exMon DM PowerBI Form

Configure Azure App Registration

To finalize the App registration you will need to make changes in the Azure Portal. 

Visit the Azure portal here and find the App under the name you registered (exMon DM Web) in the All Applications tab.

Step 1

App Registration - Authentication - Implicit Grant

  1. Click on Authentication from the left navigation menu
  2. Select Access tokens and deselect ID tokens

Step 2

App Registration - API Permissions - Grant Admin Consent for Expectus

  1. Click on API permissions from the left navigation menu
  2. Select API permissions and click Grant admin consent for Company

 

Kristinn is the author of this solution article.