Zum Hauptinhalt wechseln

Power BI connector (OData)

Use the Power BI OData connector to fetch data using Cognite's OData services. The connector is backward-compatible with existing reports, and users can authenticate with their Entra ID credentials.

Connect to Cognite Data Fusion from Power Query Desktop

Follow these steps to connect a Cognite Data Fusion (CDF) project as a data source in Power BI.

  1. In Power BI Desktop, sign in with your organization account.

  2. On the Home tab, select Get Data and then More. In the Get Data dialog, search for Cognite and select the Cognite Data Fusion (Odata) connector.

    Locate the CDF OData connector in Power BI
  3. In the dialog box, enter details to configure the connection to CDF:

    • Data Source Identifier: Enter the CDF project name, a data model URL, or a custom OData query to retrieve data from CDF. This is a required field.

      To authenticate as a guest user in Entra ID, add the Entra ID tenant ID, for example, dataSource?tenantId=MyEntraIDTenant.onmicrosoft.com.

      If you're passing a custom OData URL that already contains query parameters, then you can add the tenantId at the end with this syntax: dataSource?$filter={Filter}&tenantId=MyEntraIDTenant.onmicrosoft.com.

    • CDF API URL: Enter the URL to the Cognite API, for example, https://api.cognitedata.com or https://az-eastus-1.cognitedata.com. To access some OData services, you might also need to add the API version, for example, https://bluefield.cognitedata.com/20230821.

      Configure the CDF OData connector in Power BI
  4. When prompted, sign in with your Entra ID account credentials.

  5. Select Connect to open the Navigator window.

  6. Select the data you want to load or transform. For example, select the Assets table.

  7. Select Load to import the data directly or Transform Data to open the Power Query editor for data filtering and transformation.

Connect to Cognite Data Fusion from Power Query Online

Follow these steps to connect to CDF from Power Query Online.

  1. Select Cognite Data Fusion (OData) under Get data. See Where to get data for finding Get data in Power Query Online.

    Screenshot of the get data window with Cognite Data Fusion (OData) emphasized.
  2. In Connection settings, enter the following information:

    • Data Source Identifier: Enter the CDF project name, a data model URL, or a custom OData query to retrieve data from CDF.
      • To authenticate as a guest user in Entra ID, add the Entra ID tenant ID, for example, dataSource?tenantId=MyEntraIDTenant.onmicrosoft.com.
      • If you're passing a custom OData URL that already contains query parameters, then you can add the tenantId at the end with this syntax: dataSource?$filter={Filter}&tenantId=MyEntraIDTenant.onmicrosoft.com.
    • CDF API URL: Enter the URL to the Cognite API, for example, https://api.cognitedata.com or https://az-eastus-1.cognitedata.com. To access some OData services, you might also need to add the API version, for example, https://bluefield.cognitedata.com/20230821.
    Screenshot of the Cognite Data Fusion (OData) online connection settings.
  3. In Connection credentials, enter the following information:

    • If you're connecting to CDF for the first time, select Create new connection under Connection.

    • If you've connected previously, select an existing connection under Connection.

    • For Data gateway: If your organization uses a gateway to access CDF, select the appropriate gateway from the menu. If Data gateway is set to (none), the connector uses the Power BI service to connect to CDF directly.

    • You can also select Privacy Level for the data connection.

    • For new connections, select Sign in and follow the authentication process.

    Screenshot of the Cognite Data Fusion (OData) online connection credentials.
  4. Select Next when you've signed in.

  5. In Choose data, select the data you require, then select Create to open the Power Query editor and retrieve data from CDF.

    Screenshot of the Power Query Online Navigator showing the available tables.

Filter data

Use Transform Data to apply filters and reduce the amount of data loaded into Power BI.

Scheduled refresh

After publishing your report to the Power BI service, you can schedule data refreshes to keep your data current.

Data model URLs

If you're using data models, make sure Data Source Identifier includes the correct data model URL. See Data modeling OData service.

Custom queries

Enter custom OData queries in Data Source Identifier to retrieve specific data sets. See Custom OData queries.