# Setup and administration

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 (opens new window) to query, transform and visualize data that is stored in CDF.

The Cognite Power BI Connector communicates with CDF via the Cognite OData Service. The OData service translates the calls from Power BI into CDF REST calls.

The connector uses an API key to connect to your CDF project. The API key is stored in a safe location on your computer, and you can safely share the Power BI report with other users. To view the data in the report, the other users need their own API key.

In this article:

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

  1. 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 (opens new window).
  2. Open Power BI Desktop.

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

    Get Data

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

    Select OK.


  2. In the Authentication dialog, enter the API key to connect to the CDF project, and then select Connect.


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


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

Last Updated: 12/17/2020, 8:19:38 AM