The Hybrid Data Pipeline Power BI connector is distributed as a signed .pqx file. To install it, copy the file to Power BI Desktop's custom connectors folder and register the connector's certificate thumbprint so that Power BI trusts it.

Note: You may also customize and build the connector yourself. For details, refer to Hybrid Data Pipeline Power BI Connectors OData Connector repository.

To install the Hybrid Data Pipeline Power BI connector:

  1. Download the HdpOAuthConnect.pqx file and the TrustHdpConnector.ps1 script from the Hybrid Data Pipeline release page: https://github.com/progress/Hybrid-Data-Pipeline/releases
  2. Copy the HdpOAuthConnect.pqx file to the following folder (create the folder if it does not exist):

    Documents\Microsoft Power BI Desktop\Custom Connectors

  3. Register the certificate thumbprint using one of the following methods:
    • Script (recommended): Run the TrustHdpConnector.ps1 script as Administrator. The script adds the connector's certificate thumbprint to the Windows registry.
    • Manual: Add the connector's certificate thumbprint to the following registry key: 
      HKLM\SOFTWARE\Policies\Microsoft\Power BI Desktop\TrustedCertificateThumbprints
      Note: After registering the certificate thumbprint, you do not need to change the Power BI Desktop security setting to Allow any extension to load without validation or warning. If you are unable to run the registration script and cannot modify the registry directly, you can use this setting as a fallback. For more information about trusted third-party connectors, see Trusted third-party connectors in the Microsoft Power BI documentation.
  4. Restart Power BI Desktop.