Setup and administration for Power BI
You can use OpenID Connect and your existing identity provider (IdP) framework to manage access to CDF data securely. We currently support Microsoft Entra ID, Microsoft's cloud-based identity and access management service.
This article explains how an Microsoft Entra ID (ME-ID) administrator can register and consent for an organization to use the Microsoft Power Query for Excel application and allow the Cognite Power BI Connector to impersonate and act on behalf of a user to retrieve data from a CDF project.
When you have registered the Microsoft Power Query for Excel application, users can sign in with their organizational ID and use the Cognite Power BI Connector to retrieve data from a CDF project.
The Cognite Power BI Connector and Excel both use the Microsoft Power Query for Excel enterprise application to retrieve data from CDF. If your organization is using both the Cognite Power BI Connector app and Excel to retrieve data from CDF, you only need to register Microsoft Power Query for Excel for one of them.