If you have existing Power BI Desktop reports built with version 1.0.0 of the connector, you can update each report's data source connection when you choose to use version 2.0.0 of the connector (instead of rebuilding each report). As the following steps show, the Power Query Advanced Editor may be used to replace the Source step in each affected query with the appropriate new connector function. All other query steps, transformations, and report visuals are preserved.

To migrate an existing report to use version 2.0.0 of the connector:

  1. Open the existing Power BI Desktop report (the .pbix file).
  2. Select Transform Data to open Power Query Editor.
  3. Select the query you want to update.
    Note: A data source error is displayed for any query that uses a function that is no longer available.
  4. Select Home > Advanced Editor.
  5. Locate the Source step and replace it with the new connector function call that matches your authentication method (see the function reference below).
  6. Select Done. Enter credentials if prompted.
  7. Select Close & Apply and save the file.
  8. If using Power BI Service, take the following steps to republish the report:
    1. Republish the .pbix file to Power BI Service.
    2. In Power BI Service, update the semantic model's gateway connection to point to the new data source. See Using the Hybrid Data Pipeline Power BI connector with Power BI Service.

Supported function calls

You must use the function call that matches the report authentication method.

Note:
  • You must replace each placeholder with your actual connection parameters. For parameter descriptions, see the corresponding configuration topic.
  • HdpOAuthConnect.OIDCPublic does not have a ClientSecret parameter. The PKCE code challenge is generated automatically by the connector.

Basic authentication — HDP OData (Basic) (Custom):

Source = HdpOAuthConnect.Basic("ODataAccessURI")

OAuth 2.0 — HDP OData (OAuth 2.0) (Custom):

Source = HdpOAuthConnect.OAuth(
    "ODataAccessURI",
    "AuthorizeURL",
    "TokenURL",
    "ClientID",
    "ClientSecret",
    "RedirectURL",
    "Scope"
)

OIDC confidential flow — HDP OData (OIDC — Confidential) (Custom):

Source = HdpOAuthConnect.OIDCConfidential(
    "ODataAccessURI",
    "AuthorizeURL",
    "TokenURL",
    "ClientID",
    "ClientSecret",
    "RedirectURL",
    "Scope",
    "HDPAuthService"
)

OIDC public flow (PKCE) — HDP OData (OIDC — Public) (Custom):

Source = HdpOAuthConnect.OIDCPublic(
    "ODataAccessURI",
    "AuthorizeURL",
    "TokenURL",
    "ClientID",
    "RedirectURL",
    "Scope",
    "HDPAuthService"
)