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.
-
In
Power BI Desktop, sign in with your organization account. -
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.
-
In the dialog box, enter details to configure the connection to
CDF:-
Data Source Identifier: Enter the
CDFproject name, a data model URL, or a customODataquery to retrieve data fromCDF. This is a required field.To authenticate as a guest user in
Entra ID, add theEntra IDtenant ID, for example,dataSource?tenantId=MyEntraIDTenant.onmicrosoft.com
.If you're passing a custom
ODataURL that already contains query parameters, then you can add thetenantId
at the end with this syntax:dataSource?$filter={Filter}&tenantId=MyEntraIDTenant.onmicrosoft.com
. -
CDF API URL: Enter the URL to the
CogniteAPI, for example,https://api.cognitedata.com
orhttps://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
.
-
-
When prompted, sign in with your
Entra IDaccount credentials. -
Select Connect to open the Navigator window.
-
Select the data you want to load or transform. For example, select the Assets table.
-
Select Load to import the data directly or Transform Data to open the
Power Query editorfor data filtering and transformation.
Connect to Cognite Data Fusion from Power Query Online
Follow these steps to connect to CDF from Power Query Online.
-
Select Cognite Data Fusion (OData) under Get data. See Where to get data for finding Get data in Power Query Online.
-
In Connection settings, enter the following information:
- Data Source Identifier: Enter the
CDFproject name, a data model URL, or a customODataquery to retrieve data fromCDF.- To authenticate as a guest user in
Entra ID, add theEntra IDtenant ID, for example,dataSource?tenantId=MyEntraIDTenant.onmicrosoft.com
. - If you're passing a custom
ODataURL that already contains query parameters, then you can add thetenantId
at the end with this syntax:dataSource?$filter={Filter}&tenantId=MyEntraIDTenant.onmicrosoft.com
.
- To authenticate as a guest user in
- CDF API URL: Enter the URL to the Cognite API, for example,
https://api.cognitedata.com
orhttps://az-eastus-1.cognitedata.com
. To access someODataservices, you might also need to add the API version, for example,https://bluefield.cognitedata.com/20230821
.
- Data Source Identifier: Enter the
-
In Connection credentials, enter the following information:
-
If you're connecting to
CDFfor 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 toCDFdirectly. -
You can also select Privacy Level for the data connection.
-
For new connections, select Sign in and follow the authentication process.
-
-
Select Next when you've signed in.
-
In Choose data, select the data you require, then select Create to open the
Power Query editorand retrieve data fromCDF.
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.