I am retrieving an access token by calling an API and then use this access token to obtain employee data. I'm using a blank query with the following code.
Source = Json.Document(Web.Contents(baseUrl,
RelativePath = "oauth/issueToken",
Headers = [#"Content-Type"="application/x-www-form-urlencoded"],
token = Source[access_token],
RelativePath = "api/employees",
Headers = [#"Authorization"="Bearer "&token]
I'm getting access token calling our own API (not using AAD). What is the best way to store these client credentials (client_id and client_secret) instead of hardcoding in the code?
Besides the great option @lbendlin mentioned, with an additional API endpoint you could also use the builtin credentials manager https://community.powerbi.com/t5/Power-Query/How-to-securely-store-and-use-token-and-secret-for-API-...
store them in a text file in a sharepoint document library that only you have access to. Then retrieve that file as part of the Power Query transforms etc.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.