Skip to main content
Question

Connecting to CDF API in Power BI

  • 18 September 2024
  • 3 replies
  • 29 views

I want to visualize some data from the API directly in Power BI. For instance, I want to display data about extraction pipelines https://api-docs.cognite.com/20230101/tag/Extraction-Pipelines/operation/listExtPipes. How can I use the CDF API as a data source in Power BI and input my credentials there in the correct way? 

Thank you! 

Everton Colling
Seasoned Practitioner

Hi Sebastian,

Thank you for your question about connecting to the CDF API in Power BI to visualize extraction pipeline data.

Currently, the Cognite Power BI connector has limited capabilities and only allows fetching data from two sources:

  1. The Asset centric OData service
  2. The Data models OData service

Unfortunately, neither of these services exposes data related to extraction pipelines, which means you cannot directly access the information you're looking for using the current connector.

However, I'm pleased to inform you that we are actively working on an updated version of the Power BI connector. This new version will expand its capabilities, allowing users to fetch data from Cognite REST APIs using GET and POST requests. This update will enable you to access a wider range of data, including extraction pipeline information.

We anticipate releasing this new connector in the coming months, aiming to have it available in time for the December release of Cognite Data Fusion.

In the meantime, if you need immediate access to this data in Power BI, you might consider alternative methods such as periodically copying data from Extraction Pipelines into Sequences, which can be read directly using the Asset centric OData service.


Ok. Thanks for the quick response! Could using the python SDK be another option? https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts#run-the-script-and-import-data


Everton Colling
Seasoned Practitioner

Yes, that will work fine locally, but as far as I know, Python scripts are not yet supported on Power BI service. That means, you’ll have to refresh the report from your computer using Power BI desktop, which is not ideal.


Reply


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings