Configure Connection to Power BI Scanner Source

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

After you install the Azure Power BI Scanner OCF connector, you must configure the connection to the BI source.

The various steps involved in configuring the Azure Power BI Scanner source connection are:

Provide Access

Go to the Access tab on the Settings page of your BI source

You can configure the visibility of a BI source and its child objects such as Folder and Report on the Access tab of the settings page. Refer to for information on how to configure the object privacy settings.

Configure BI Source Visibility

Applies from release 2023.3.5

On the Access tab, follow these steps to set the BI source visibility:

  1. Select one of the following options for setting privacy level:

  • Public BI Server—The BI source will be visible to all users of the catalog.

  • Private BI Server—The BI Source will be visible to users that have been assigned the BI Server Admin or Viewer role. It will be hidden for all other users.

  1. Add one or more BI Server Admins or Viewers in the User Access section if required.

For more information on BI Source, see Configure Access to OCF BI Sources

Configure BI Folder and Report Visibility

Applies from release 2024.1.4

On the Settings under a BI Folder or Report, follow these steps to set visibility:

  1. Check the option Enable explicit permission to change access permission defined at the parent level object.

    This enables and allows permissions at the object level. By default, the access permissions are inherited from the parent level and are not editable.

  2. Select one of the following options for setting privacy level:

  • Public—The BI folder or report will be visible to all users of the catalog.

../../../_images/BI_Folder_Access.png
  • Private—The BI folder or report will be visible to users that have been assigned the BI Server Admin or Viewer role. It will be hidden for all other users.

../../../_images/BI_Report_Access.png
  1. Add one or more BI Server Admins or Viewers in the User Access section if required.

For more information on how to enable the feature and configure access to a folder or report, see Configure Access to OCF BI Folders and Reports

Connect to BI Source

To connect to the BI source, you must perform these steps:

Provide the Connection URLs

To provide to the connection URL in the Alation UI, perform these steps:

From Alation version 2024.1.4 and connector version 2.3.0

  1. On the Settings page of your BI source, go to the General Settings tab.

  2. In the Provide the connection URLs section, enter the following details:

Parameter

Description

PowerBI API URL

Specify the API URL to access Power BI APIs. The default values are: https://api.powerbi.com/v1.0/myorg/ for enterprise and https://api.powerbigov.us/v1.0/myorg/ for Azure Government Cloud

Access Token URL

Specify the API URL to generate the Access Token. The default value is https://login.microsoftonline.com/common/oauth2/token

PowerBI Resource URL

Specify the Power BI Resource URL to grant access scope to Power BI APIs. The default values are: https://analysis.windows.net/powerbi/api for enterprise and https://analysis.usgovcloudapi.net/powerbi/api for Azure Government Cloud

  1. Click Save.

Configure Authentication

To configure authentication in the Alation UI, perform these steps:

From Alation version 2024.1.4 and connector version 2.3.0

  1. On the Settings page of your BI source, go to the General Settings tab.

  2. In the Configure authentication section, enter the following details:

Parameter

Description

Azure tenant ID

Specify the Directory (tenant) ID of the application registration.

Client ID

Specify the Application (client) ID of the application registration.

Client Secret

Specify the client secret of the application registration.

  1. Click Save.

Configure Proxy Settings

Note

This step is optional.

If Azure Power BI Scanner is connected using proxy connection, provide the following details:

From Alation version 2024.1.4 and connector version 2.3.0

  1. On the Settings page of your BI source, go to the General Settings tab.

  2. In the Proxy configuration section, enter the following details:

Parameter

Description

Proxy URL

Specify the URL to access Power BI using a proxy server.

Proxy Port

Specify the proxy port number.

Proxy Username

Specify the proxy server username.

Proxy Password

Specify the proxy server password.

  1. Click Save.

Test the Connection

The connection test checks BI server connectivity. Alation uses the connection information you provided to confirm when the connection is established.

After specifying the connection details in Configure Authentication , test the connection.

To validate the network connectivity, go to General Settings > Test connection of the Settings page of your BI server source and click Test.

A dialog box appears confirming the status of the connection test.

Alation checks to ensure that the Service Principal is valid and also verifies the connection details before establishing the connection.

Configure Advanced Settings

Note

This step is optional.

Apart from the mandatory configurations that you perform to connect to the BI Server source in the General Settings tab, you can configure the following additional settings:

Configure BI Server Lookup URI

You ust provide the BI Server Lookup URI to redirect users to BI objects from their respective catalog pages using the Connector link on the catalog page. Perform these steps to provide the BI Server Lookup URI:

From Alation version 2024.1.4 and connector version 2.3.0

  1. Go to General Settings > Advanced settings section of the Settings page of your BI Server source.

  2. Provide the BI server URI for in the BI server lookup URI field to redirect users to BI objects from their respective catalog pages using the Connector link on the catalog page.

    For example: For PowerBI enterprise, you can include https://app.powerbi.com/ as a BI server lookup URI.

  3. Click Save.

Enable or Disable Automatic Lineage Generation

You can enable or disable the lineage for the BI Server source to be generated automatically during metadata extraction.

From Alation version 2024.1.4 and connector version 2.3.0

Go to General Settings > Advanced settings of the Settings page of your BI Server source and enable or disable the Disable automatic lineage generation toggle.

Turn off the Disable automatic lineage generation toggle to skip the creation of automatic Lineage after extraction. When automatic Lineage generation is disabled, during extraction Alation does not calculate lineage data for this BI source.

Turn on this option when you want generate lineage automatically.

Configure Logging

To set the logging level for your BI source logs, perform these steps:

From Alation version 2024.1.4 and connector version 2.3.0

  1. On the Settings page of your BI Server source, go to General Settings > Connector logs.

  2. Select a logging level for the connector logs and click Save.

    The available log levels are based on the Log4j framework.