Retrieve data from Cognite Data Fusion (CDF) in Excel
This article explains how you can connect a Cognite Data Fusion (CDF) project as a data source in Excel to query, transform and visualize data that is stored in CDF.
NOTE
The steps below assume that an administrator has followed the instructions in Setup and administration for Excel to register and consent for an organization to use the Microsoft Power Query for Excel application and allow Excel to use it to impersonate and act on behalf of a user to retrieve data from a CDF project.
Use a CDF project as a data source in Excel
To connect to a CDF project and use it as a data source in Excel:
In Excel, select Data > Get data > From Other Sources > From OData Feed.
Enter the URL for the CDF project you want to connect to:
- 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
.
- Where <cluster> is the name of the CDF cluster, for example
In the Authentication dialog, select Organizational account and then Sign in with your organizational ID.
Select Connect.
In the Navigator, select a table, for instance Timeseries, and then select Transform Data.
TIP
You probably don't want to load the full table as it could contain hundreds of thousands of entries.
You can now transform the data with the Power Query Editor.
If you want to limit the data set, you can, for example, select Keep Rows > Keep Top Rows and set a value, for instance 1000.
To load the resulting values into Excel, select Close and Apply.