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!
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:
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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.