Retrieve data from Cognite Data Fusion (CDF) in Power BI
Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website.
This article explains how you can use the Cognite Power BI connector to connect a Cognite Data Fusion (CDF) project as a data source in Power BI Desktop to query, transform and visualize data that is stored in CDF.
The steps below assume that an administrator has followed the instructions in Setup and administration for Power BI to register and consent for an organization to use the Microsoft Power Query for Excel application and allow the Cognite Power BI Connector 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 Power BI Desktop
To connect to a CDF project and use it as a data source in Power BI Desktop:
First, make sure that you have installed the March 2020 version (or later) of Power BI Desktop. To automatically stay updated with the latest version, download Power BI Desktop from the Microsoft Store.
In Power BI Desktop, make sure that you sign in with your organizational account.
On the Home tab in the ribbon, select Get Data and then More. Then, in the Get Data dialog box, select Other and the Cognite Data Fusion connector.
Enter the CDF project that you want to connect to, for example, publicdata.
Optional: If the CDF project is on a custom cluster, set the CDF Environment to the URL of the API server for the cluster. If you're not sure, leave the field blank.
In the Authentication dialog, select Organizational account and then Sign in with your organizational ID
Optional: If your organization is using API keys to control access to the CDF project, select API key and specify the API key to connect to the CDF project.
We are deprecating authentication via CDF service accounts and API keys.
Select a table, for instance Timeseries, and then select Transform Data.
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 Power BI, select Close and Apply.
Learn more about Power BI: