Progress DataDirect Hybrid Data Pipeline User's Guide Release 5.0.0

Configuring the Hybrid Data Pipeline Power BI connector for OIDC public flow (PKCE)

Save PDF

Save PDF

Before configuring the connector, ensure the following are in place:

Power BI Desktop is installed. Download it from https://powerbi.microsoft.com/en-us/downloads/.
The Hybrid Data Pipeline Power BI connector is installed and the certificate thumbprint is registered. See Installing the Hybrid Data Pipeline Power BI connector.
An OData-enabled Hybrid Data Pipeline data source and the URI for the data source. See Creating an OData-enabled Hybrid Data Pipeline data source.
An Identity Provider (IdP) is configured to access the Hybrid Data Pipeline server. See Integrating an OIDC authentication service.
The OIDC service is registered as an external authentication service with Hybrid Data Pipeline. See Registering the client application with the Hybrid Data Pipeline server.
A separate Azure AD app registration exists with a Single Page Application (SPA) redirect URI. This must be a separate registration from any confidential flow app. For SPA redirect URI requirements, see Microsoft identity platform and OAuth 2.0 authorization code flow in the Microsoft documentation.

To connect Power BI Desktop to Hybrid Data Pipeline using the OIDC public flow with PKCE (Proof Key for Code Exchange):

Enter values for the following parameters, then select OK:


Parameter	Description
OData Access URI	The OData access URI for your Hybrid Data Pipeline data source
Authorize URL	The authorization endpoint URL of your IdP
Token URL	The token endpoint URL of your IdP
Client ID	The client ID from your Azure AD app registration
Redirect URL	The SPA redirect URI registered in your Azure AD app
Scope	The scope value(s) required by your Hybrid Data Pipeline server
HDP Auth Service	The name of the OIDC authentication service registered with Hybrid Data Pipeline

Note: No client secret is required. The PKCE code challenge is generated automatically by the connector.