How do I find the Account key for power bi Data source credentials

Question

I cannot edit my Data source credentials - how do I find the account key?

Answer 1

Hi CEH

In Power BI, the account key for data source credentials is often referred to as the "OAuth 2.0 Access Token" or simply the "Access Token." The Access Token is used for authentication when connecting to data sources that support OAuth 2.0 as the authentication method.

To obtain the Access Token for data source credentials in Power BI, you generally need to go through the OAuth 2.0 authentication flow. The steps to get the Access Token can vary depending on the data source you are connecting to. Here's a general outline of how you can obtain the Access Token for common data sources:

1. Power BI Service Data Source Credentials (Web Services): For data sources that use OAuth 2.0, such as web services like Microsoft Graph API, you typically need to register your application in the respective service's developer portal to obtain the necessary credentials (client ID and client secret). Then, you can use these credentials along with your authentication request to obtain the Access Token.
2. Azure Active Directory (Azure AD) Authentication: When using Azure AD authentication to connect to Azure data sources (Azure SQL Database, Azure Data Lake, etc.), you can use the Power BI service's built-in integration with Azure AD. Power BI will handle the authentication and obtain the Access Token behind the scenes.
3. Other OAuth 2.0 Supported Data Sources: For other data sources that support OAuth 2.0, you'll need to consult the documentation of the specific data source to find out how to obtain the Access Token. Many APIs and web services have their own authentication flows and endpoints for getting the Access Token.

It's important to note that the Access Token is usually temporary and has an expiration time. After the token expires, you may need to refresh it using a refresh token (if applicable) or go through the authentication flow again to obtain a new Access Token.

Keep in mind that the process of obtaining the Access Token involves security considerations, and you should follow best practices to protect your credentials and tokens.

For a step-by-step guide on how to connect to different data sources and set up data source credentials in Power BI, you can refer to the official Power BI documentation or the documentation of the specific data source you are working with.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".