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. Learn more about Power BI at: https://powerbi.microsoft.com/.
This article explains how you can use the Cognite Power BI connector with Power BI Desktop to query, transform and visualize data that is stored in Cognite Data Fusion (CDF).
Follow these steps to get up and running with the Cognite Power BI connector:
- Step 1. Download and install the Cognite Power BI connector
- Step 2. Enable the connector
- Step 3. Connect to Cognite Data Fusion
Step 1. Download and install the Cognite Power BI connector
To download the latest Cognite Power BI connector, copy and paste this link into a browser window:
When the download has completed, open the download folder to find the
Cognite.mezfile to your
[Documents]\Power BI Desktop\Custom Connectorsfolder.
Note: You need to manually create both the
Power BI Desktopand
Custom Connectorsfolders if they don't already exist.
Step 2. Enable the connector
The connector is currently being certified by Microsoft, but until the certification has completed, you need to enable the connector manually. Installing and enabling the connector is a one time operation.
- Open Power BI Desktop.
- Select File > Options and Settings > Options.
- Select the Security tab.
- In the Data Extensions section, select Allow any extension to to load without validation or warning.
- Select Ok to save your settings.
- To restart Power BI, select File > Exit, and open Power BI Desktop again.
Learn more at: Connector extensibility in Power BI.
Step 3. Connect to Cognite Data Fusion
The next step is to add a Cognite Data Fusion project as a data source for Power BI.
On the Home tab in the ribbon, select Get Data and then select Other. Select the Cognite Data Fusion (Beta) connector.
If you get a warning message about connecting to a third-party service, select Continue.
Enter the CDF project that you want to connect to, for example, publicdata and select OK.
In the Authentication dialog, enter your organizational account or ApiKey to connect to the CDF project, and then select connect.
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 query within Power Query.
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.