Configuring a Power BI custom connector for OAuth 2.0

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/.
• Register Power BI as a client application with the Hybrid Data Pipeline server to obtain a client ID and client secret. See Register the client application with the Hybrid Data Pipeline server and Using OAuth 2.0 for authorizing client application access to Hybrid Data Pipeline data sources 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: OAuth 2.0

   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

   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 Hybrid Data Pipeline 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.