Connections > Microsoft Power BI connection properties > Connect to Microsoft Power BI

Connect to Microsoft Power BI

Configure the Microsoft Power BI connection properties to connect to Microsoft Power BI.

Before you begin

Before you get started, you'll need to get information from your Microsoft Power BI account based on the connection mode that you want to configure.

Check out Prepare for authentication to learn more about the authentication prerequisties.

Connection details

The following table describes the basic connection properties:

Property	Description
Use Secret Vault	Stores sensitive credentials for this connection in the secrets manager that is configured for your organization. This property appears only if secrets manager is set up for your organization. This property is not supported by Data Ingestion and Replication. When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured. For information about how to configure and use a secrets manager, see Secrets manager configuration.
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
Description	Description of the connection. Maximum length is 4000 characters.
Runtime Environment	The name of the runtime environment where you want to run tasks. Select a Secure Agent or serverless runtime environment.
Authentication Type	The authentication type to use for the connection. Choose to connect using the Admin User option or the Service Principal option.
Power BI service URL	The URL to access Microsoft Power BI and connect to the REST API. For example, https://api.powerbi.com/

Authentication types

You can configure your Microsoft Power BI connection to use either the Admin User or Service Principal authentication type.

Select the required authentication type and then configure the authentication-specific parameters.

Admin User authentication

Admin User authentication requires your Microsoft Power BI account user name and password.

The following table describes the connection properties for the Admin User authentication:

Property	Description
Client ID	The ID to connect to the Microsoft Power BI cloud host. Enter the application ID or client ID for your Power BI app registered in Microsoft Azure Portal.
User Name	User name of the administrator to connect to the Microsoft Power BI cloud host.
Password	The password of the administrator account to connect to the Microsoft Power BI cloud host.

Service Principal authentication

Service Principal authentication requires the Tenant ID and client secret of your application registered in Azure Active Directory.

The following table describes the connection properties for the Service Principal authentication:

Property	Description
Authentication URL	URL for user authentication.
Scope	Parameter that the endpoint uses to authenticate the user.
Client ID	The ID to connect to the Microsoft Power BI cloud host. Enter the application ID or client ID for your Power BI app registered in Microsoft Azure Portal.
Tenant ID	Name of the Azure Active Directory tenant.
Client Secret	The client secret key to complete OAuth Authentication in the Azure Active Directory.