Cognite Power BI connector
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 use 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.
Connect to Cognite Data Fusion (CDF)
Follow the steps below to connect to a CDF project and use it as a data source in Power BI Desktop.
First, make sure that you have:
- An API key with access to the CDF project you're connecting to.
- 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.
Open Power BI Desktop.
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 (Beta) connector.
Enter the CDF project that you want to connect to, for example, publicdata and select OK.
In the Authentication dialog, enter the API key to connect to the CDF project, and then select Connect.
Select a table, for instance Timeseries, and then select Transform Data.
NOTE: 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: