Configuring a Power BI custom connector for OIDC

Prerequisites

The following prerequisites must be met before you begin.

• Install Power BI desktop application. Power BI may be downloaded from https://powerbi.microsoft.com/en-us/downloads/.
• Configure an Identity Provider (IdP) to access the Hybrid Data Pipeline server. See Integrating an OIDC authentication service for details.
• Register the OIDC service as an external authentication service with the Hybrid Data Pipeline. See Registering an OIDC authentication service for details.
• Create an OData-enabled data source. See Create an OData-enabled Hybrid Data Pipeline data source for details.

Configure the Power BI connector

Take the following steps to configure the Power BI connector to access Hybrid Data Pipeline resources.

1. Download the Power BI custom connector from the GIT location Hybrid Data Pipeline public GitHub repository.
2. Copy the PQX file to the Power BI custom connectors directory: Documents\Microsoft Power BI Desktop\Custom Connectors.
3. Launch the Power BI desktop application.
4. Click Get Data on the menu. The Get Data window appears.
5. On the Get Data window, click Other in the left pane.
6. Select Hybrid Data Pipeline OData Connector from the list.
7. Click Connect.

   

8. In the Hybrid Data Pipeline OData Connector window, enter your values for the following fields. For example:

   OData Access URI: https://myhdpserver:8080/api/odata/datasource_name

   Authentication Method: OIDC

   Authorize URL: https://login.datasource.com/oauth2/v1/authorize

   Token URL: https://login.datasource.com/oauth2/token

   Client ID: ee5665-69ld-7963-1234-fsfhd368463c

   Client Secret: 9898tukt-gh92-1221-0670-bcdfe456324z

   Redirect URL: https://oauth.powerbi.com/views/oauthredirect.html

   HDP Auth Service: oidc_okta

   Hybrid Data Pipeline OData Connector

   
9. Click OK. A dialog box appears for signing in with the Hybrid Data Pipeline OData connector.
10. Select OAuth 2.0 and click Sign in.

    

11. Enter your IdP credentials. Click OK. You are redirected to the Hybrid Data Pipeline OData connector page. You are now signed in.
12. Click Connect. You are connected to Hybrid Data Pipeline OData endpoints.