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.

Set up a connection to Cognite Data Fusion

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 organizational 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.

   

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 are 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 may also need to add the API version, for example, https://bluefield.cognitedata.com/20230821.

     

4. When prompted, sign in with your Entra ID account credentials.

5. Select Connect to open the Navigator window.

6. Select the data you wish 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.

Filtering data

Use the Transform Data option 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 that Data Source Identifier includes the correct data model URL. For more information, see Data modeling OData service.

Custom queries

You can enter custom OData queries in the Data Source Identifier field to retrieve specific datasets. For more information, see Custom OData queries.