Datamining Report & Power BI Endpoints

Modified on Wed, 12 Nov at 4:16 PM

TABLE OF CONTENTS

Introduction
Further Support

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 - Enable Endpoint for Datamining Reports

Navigate to Administration -> Project Settings (1)
Click on Project Policies (2)
Scroll down to the Report Endpoints panel and Enable Endpoint for Datamining Reports (3). This will enable datamining endpoints for PowerBI
Click Save Changes (4)

The User needs to be in the 'Run Endpoint Datamining Reports' role to access the Endpoint.

Step 2 - Create the required Datamining Report

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

Navigate to Administration -> Portal Settings.
Click New Datamining Report (2)
Select the required module, in this example, we are creating a User Migrations report (3)

Click Add Reporting Tier and select Applications.

Select the fields to be included in the report
Click Run Datamining Report
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
Brief Description of the Report

Step 3 - Enable Power BI Endpoints

Close the datamining report
Navigate to Administration -> Portal Settings (1)
Locate and select your datamining report (2)
In the panel on the right side, scroll down to the Enable Power BI Endpoints (3)
Select the endpoints required for the integration
Click Save Changes (4)

Step 4 - Connect Power BI with the Datamining Report

it's possible to connect to the Datamining Report Endpoint either anonymously or with authentication. An example of each is outlined below.

Click the Copy to Clipboard icon next to the required URL.
Launch Power BI.
Create a new Blank Report.
Click Get Data.
Type in Web (1) in the search box.
Select Web (2) from the results.
Click Connect (3).

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

Anonymous Connection

In the From Web dialog choose the Basic option.
Paste in the copied URL.
(Optional) In order to format the column headers in the Power BI report, Headerformat settings can be appended to the URL:
- http://server/1/p/u/dmr/1017/pbi3/db68bf3b-def6-4be4-9449-3956f9f1c11d?Headerformat=PrefixedName
- http://server/1/p/u/dmr/1017/pbi3/db68bf3b-def6-4be4-9449-3956f9f1c11d?Headerformat=InternalName
- http://server/1/p/u/dmr/1017/pbi3/db68bf3b-def6-4be4-9449-3956f9f1c11d?Headerformat=DisplayName
Click OK.
Power BI with display the contents of the Datamining Report with the chosen Headerformat (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.

Authenticated Connection

Two options are available:

Username and Password
Token

Username and Password

Copy the Power BI Authenticated Url.
Launch Power BI.
Create a new Blank Report.
Click Get Data.
Type in Web in the search box.
Select Web from the results.
Click Connect.
In the From Web dialog, click on Advanced option.
Paste in the Authenticated URL (1).
Within the HTTP request header parameters (optional) (2).
- Type in Username and enter your ManagementStudio username.
- Click Add Header (3).
- Type in Password and enter your ManagementStudio password.
Click OK (4).
Power BI will display the contents of the Datamining Report with the chosen Headerformat (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.

Token

The password for an account with access to the Datamining Report must be known to generate the token:

Switch to ManagementStudio.
Administration -> User Accounts (1).
Click Create Auth Token (2).

Enter the User Name and Password for an account.
Set the Token expiry date.
Click Create Token.
Copy the token and close the dialog.

Establishing the Connection in Power BI

Launch Power BI.
Create a new Blank Report.
Click Get Data -> Web.
In the From Web dialog, click Advanced (1).
Within the HTTP request header parameters (optional) (3) type in Token and paste in the generated token.
In ManagementStudio copy the Datamining Report Power BI AuthenticatedUrl.
Paste this into URL parts (2)
Click OK (4).
Power BI will display the contents of the Datamining Report.
Click Close & Apply.

Further Support

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