Skip to main content

Power BI: Retrieve data from CDF

Connect a Cognite Data Fusion (CDF) project as a data source and use Power BI to query, transform, and visualize the CDF data.

info

Before you can sign in with your organizational ID and retrieve data from CDF, an administrator needs to register and consent for your organization to use Microsoft Power Query for Excel.

  1. In Power BI Desktop, sign in with your organizational account.

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

    Get data

  3. Enter the CDF project you want to connect to, for example, publicdata. You might also have to add the IdP tenant ID, for example, my-project?tenantID=MyAzureADTenant.onmicrosoft.com.

    Project Sign in guest

    Also, set the CDF Environment to the URL of the API server for the cluster. This takes the form of, for example, api.cognitedata.com, az-eastus-1.cognitedata.com, etc., and can also be seen in your web browser URL when logging into the CDF GUI. If you're not sure, leave the field blank.

  4. In the Authentication dialog, select Organizational account and then Sign in with your organizational ID.

    Authentication

  5. Select Connect.

  6. Select a table, for instance, Time series, and then select Transform Data.

    caution

    The table can contain hundreds of thousands of entries. Don't select Load unless you want to load all entries.

    Navigator

  7. You can now transform the data with the Power Query Editor.

    To limit the data set, you can, for example, select Keep Rows > Keep Top Rows and specify the number of rows to keep.

    Navigator

    To load the resulting values into Power BI, select Close and Apply.

Learn more about Power BI:

Last updated