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

  1. To download the latest Cognite Power BI connector, copy and paste this link into a browser window:

    https://storage.googleapis.com/cognite-odata-connectors/Cognite.mez

  2. When the download has completed, open the download folder to find the Cognite.mez file.

  3. Copy the Cognite.mez file to your [Documents]\Power BI Desktop\Custom Connectors folder.

    Paste

    Note: You need to manually create both the Power BI Desktop and Custom Connectors folders 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.

  1. Open Power BI Desktop.
  2. Select File > Options and Settings > Options.
  3. Select the Security tab.

Security

  1. In the Data Extensions section, select Allow any extension to to load without validation or warning.
  2. Select Ok to save your settings.
  3. 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.

  1. On the Home tab in the ribbon, select Get Data and then select Other. Select the Cognite Data Fusion (Beta) connector.

    Get Data

    If you get a warning message about connecting to a third-party service, select Continue.

  2. Enter the CDF project that you want to connect to, for example, publicdata and select OK.

    Project

  3. In the Authentication dialog, enter your organizational account or ApiKey to connect to the CDF project, and then select connect.

    Authentication

  4. 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.

    Navigator

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.

Last Updated: 12/10/2019, 9:02:45 AM