Configure Connection to the Power BI Source

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Configure the On-Prem Power BI Source

  1. Configure the connection to the Power BI server:

    On the Access tab, set the BI source visibility as follows:

    • 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.

    ../../../_images/PBIOnPremServerSettings.png

    You can add more BI Admins or Viewers in the User Access section if required. For more information, see Configure Access to OCF BI Sources

  2. Perform the configuration on the General Settings tab:

Specify Application Settings:

Parameter

Description

Enable automatic lineage

Leave this checkbox selected (default).

Disable Permission Enforcement

Leave this checkbox selected (default).

Permission enforcement is not supported between Power BI and Alation.

Disable Certification

Leave this checkbox selected (default).

Certification of BI objects in Power BI from Alation is not supported.

Server URI

Enter the server URI used to access Power BI

Click Save to save the information you have entered.

Specify Connector Settings:

Parameter

Description

Power BI Web URL

Enter the URL to access Power BI. For example:

https://app.powerbi.com/

Power BI API URL

Enter the API URL to access Power BI APIs. Example:

https://api.powerbi.com/v1.0/myorg/

Power BI Domain

Enter the Power BI Domain

Power BI User

Enter the Power BI User

Power BI Password

Enter the Power BI Password

Power BI Catalog Hidden Pages

Choose if hidden pages should be cataloged

Authentication Type

Choose to enable Kerberos, NTLM, or basic auth

Upload Krb5 config

Upload your Krb5 file for Kerberos configuration

Enable SSL

If enabled the connector will use SSL when establishing connections

Truststore password

The password is used to protect the temporal truststore that stores the SSL certificate. The truststore is deleted when the JDBC connection is closed.

Alation Base URL

Enter the based URL to your alation catalog

Alation API Token

Enter the Alation API Token

Click Save.

  1. Under Test Connection, click Test to validate network connectivity.