Establish Connectivity to Azure Analysis Services

This article describes how to connect to Microsoft Azure Analysis Services.

PREREQUISITES;

This connection requires creating a Remote Agent.

Expand or collapse content Locate Values for Location, Model, and Server

Access Microsoft Azure Portal

  1. Find Analysis Services.
  2. Access the service and locate Location and Model values as shown on the screenshot above.
Expand or collapse content Register an Application – for OAuth

Access Microsoft Azure Portal

  1. Access App registrations.
  2. Input a descriptive name.
  3. Specify Supported account types as shown on the screen.
  4. Choose "Web" from the Redirect URI.drop-down and set the value for Redirect URI in the following format:
    • https://hostname/editor/service/validatepowerbioauth
  5. [Register]

Locate Appplication ID

Access the Overview tab

Locate Application ID as shown on the screenshot.

Create Client Secret

Access the Certificates & secrets tab

  1. [+New client secret].
  2. Enter Description.
  3. Specify validity period.
  4. [Add]
  5. Copy the Client secret Value.
    • NOTE: Be aware, that the Value won't be available after you perform another operation or leave the tab.

Enable Permissions

Access the API permissions tab

  1. [+Add a permission]
  2. Under APIs my organization uses, find Azure Analysis Services.
  3. Select Model.ReadWrite.All
    • The permission allows the app to view and write to all models for the signed-in user and models to which the user has access.
    • NOTE: Microsoft Graph-User.Read is also a required permission and it is added by default upon the app creation. The permission allows users to sign in to the app, and allows the app to read the profile of signed-in users. It also allows the app to read basic company information of signed-in users.
  4. [Add permissions]

1. Add New Data Source

Access Admin > Collection > Storage > Data Sources

  1. [+New Data Source]
  2. Choose "Azure Analysis Services" from Plugin drop-down list.
  3. [Next Step]

2. Define Required Parameters

  1. Input a descriptive phrase in Data Source Name.
  2. Select the required Auth Type.
    • Password: Provide Azure account credentials (Username and Plugin Password).
    • Identity Profile: Select the Identity Profile from drop-down menu.
    • OAuth: Input the Azure app data (Application ID and Client Secret) copied in this section. Afterwards, click [Get New Token].
  3. Location, Model and Server: Insert Location, collected in Azure account.
  4. Optionally, toggle on Enable On-Demand Element Creation.

3. Add RDP

Click [+New Remote Processor] and select the Remote Agent from the drop-down list.

[Test Connection] to check if Metric Insights connects with plugin correctly.