Excel: Retrieve data from CDF

Connect a Cognite Data Fusion (CDF) project as a data source and use Excel to query, transform and visualize the CDF data.

info

Before you can sign in with your organizational ID and retrieve data from CDF, an administrator needs to register and consent for your organization to use Microsoft Power Query for Excel.

1. In Excel, select Data > Get data > From Other Sources > From OData Feed.

2. Enter the URL for the CDF project you want to connect to:

   https://<cluster>.cognitedata.com/odata/v1/projects/<project>

   • Where <cluster> is the name of the CDF cluster, for example, westeurope-1.
   • Where <project> is the name of the CDF project, for example, cogtosoorg.

3. In the Authentication dialog, select Organizational account and then Sign in with your organizational ID.

4. Select Connect.

5. Select a table, for instance, Time series, and then select Transform Data.

   caution

   The table can contain hundreds of thousands of entries. Don't select Load unless you want to load all entries.

   

6. You can now transform the data with the Power Query Editor.

   To limit the data set, you can, for example, select Keep Rows > Keep Top Rows and specify the number of rows to keep.

   

7. To load the resulting values into Excel, select Close and Apply.