This feature is currently in Preview and not ready for production purposes
PowerBI can be embedded into the exMon DM Web interaface 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 treeand click Add New PowerBI Report.
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 embedd 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
- For further information about App registration see
https://docs.microsoft.com/en-us/power-bi/developer/embedded/register-app
In Step 1 Sign-In with your Office 365 credentials
In Step 2 fill out the registration form as follows
- Application Name - exMon DM Web
- Application Type - Native
- API Access - Select All
Click Register and you should see the following dialog, 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.
Go to https://portal.azure.com/#blade/Microsoft_AAD_RegisteredApps/ApplicationsListBlade/quickStartType//sourceType/ and find the App under the name you registered (exMon DM Web) in All Applications tab.
Step 1 App Registration - Authentication - Implicit Grant
Click on Authentication from the left navigation menu and select Access tokens and deselect ID tokens
Step 2 App Registration - API Permissions - Grant Admin Consent for Expectus
Click on API permissions from the left navigation menu and select API permissions and click Grant admin consent for Company