TABLE OF CONTENTS


Introduction

Clear and accurate reporting tools play a vital role in any organisation decision today. As businesses strive to become more data-driven, vivid presentations offer powerful medium to harness and understand information. Power BI is a business analytics tools that is used to analyse data and share insights in the form of reports and dashboards.  A Datamining Report in ManagementStudio can be published as a Power BI Endpoint that Power BI can connect to either authenticated with a Username / Password or anonymously. This article walks through the steps required to create a Datamining report, publishing it as a Power BI Endpoint and integrating with Power BI.  For information on getting started with Power BI, please refer to this article.


How to integrate a Datamining Report with Power BI

The example that follows will use the User Migrations module to illustrate the concept, although this approach applies to all modules within ManagementStudio.


Step 1 - Configure Power BI Endpoints

  • Navigate to Administration -> [Module] User Migrations -> Portal (1). 
  • Ensure the checkbox Is Enabled is ticked (2).
  • Within the DMR Json Endpoint, ensure the relevant checkboxes are ticked based on requirements (3).
  • Allow Authenticated Endpoints - For a secure connection
  • Allow Anonymous Endpoints - For Anonymous connection
  • Click Save Changes (4).



               

Step 2 - Create the required Datamining Report

The example that follows will generate a User-Applications report.

  • Navigate to the User Migrations (1) module.
  • Click on the Datamining Report button (2).


  • Click Add Reporting Tier (3) and select Applications (4).
  • Select the fields to be included in the report.
  • Click Run Datamining Report (5).



  • This will present a report similar to this. A User-App Datamining report.


An example of a User-Application report


  • Perform any sorting, filtering, reordering and removing of columns in the DMR so that only the columns/rows you want to display remains. 
  • Click Run Datamining Report.
  • Click Save Report button.
  • Enter the name of the report (1).
  • Brief description of the report (2).
  • Tick the required connection (3).
  • Click Save New (4).



Step 3 - Connect Power BI with the Datamining Report

  • Load and run the created report from step 2.
  • Click Menu and select Power BI Endpoints.
  • The screenshot below will be presented with URLs that a User can copy to the clipboard.


Power BI Authenticated Endpoint

1

Display Name - URL used to display the column headers as displayed in the Datamining Report. E.g. App Vendor, App Name

2

Internal Name - URL used to display the column headers as the internal name. E.g. Applications_AppVendor

Power BI Anonymous Endpoint

3

Display Name - URL used to display the column headers as displayed in the Datamining Report. E.g. App Vendor, App Name

4

Internal Name - URL used to display the column headers as the internal name. E.g. Applications_AppVendor


  • Click the Copy to Clipboard (5) icon next to the required URL.
  • Launch the Power BI application.
  • Click Get Data.
  • Type in Web (1) in the search box.
  • Select Web (2) from the results.
  • Click Connect (3).


  • In the From Web dialog, paste the URL copied.


The Basic option is used for the Anonymous URL and the Advanced is used for the Authenticated URL.



  • Click OK.
  • You will be presented with the connecting dialog box.

  • You will be presented with the interface similar to the below displaying the contents of the datamining report with the display names (1).
  • Click Close & Apply (2).

  • Once the connection and model has been loaded, a user can now build visuals with the data.
  • For further information about getting started with Power BI, please refer to this article.




Further Support

If you require further support, please visit ManagementStudio's Service Desk to search the knowledge base or create a new support ticket.