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

Attention: Microsoft recommends against using client secrets in custom connector OAuth flows, as the secret may be exposed via extension inspection or network traffic. For a more secure alternative that does not require a client secret, see Configuring the Hybrid Data Pipeline Power BI connector for OIDC public flow (PKCE).

To connect Power BI Desktop to Hybrid Data Pipeline using OAuth 2.0 authentication:

  1. In Power BI Desktop, select Get Data > Other.
  2. Select HDP OData (OAuth 2.0) (Custom), then select Connect.
  3. 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 OAuth 2.0 provider
    Token URL The token endpoint URL of your OAuth 2.0 provider
    Client ID The client ID assigned when Power BI was registered as a client application
    Client Secret The client secret assigned when Power BI was registered as a client application
    Redirect URL The redirect URI registered for the client application
    Scope The OAuth 2.0 scope value(s) required by your Hybrid Data Pipeline server
  4. When prompted to sign in, enter your credentials, then select Connect.