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.

When you set up a Microsoft Power BI connection, you must configure the connection properties.

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

Select the required connection mode and then configure the authentication-specific parameters.

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

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

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 connection mode 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 connection mode:

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.