Generating Token Dynamically from Power BI Desktop

Hi Anonymous ,

You can try the following code in general:

let
    GenerateToken = () =>
    let
        url = "https://login.mypurecloud.com.au/oauth/token",
        body = "grant_type=client_credentials&client_id=YOUR_CLIENT_ID&client_secret=YOUR_CLIENT_SECRET",
        headers = [#"Content-Type" = "application/x-www-form-urlencoded"],
        response = Web.Contents(url, [Headers=headers, Content=Text.ToBinary(body)]),
        jsonResponse = Json.Document(response),
        accessToken = jsonResponse[access_token]
    in
        accessToken
in
    GenerateToken

let
    token = GenerateToken(),
    url = "https://api.yourservice.com/data",
    headers = [#"Authorization" = "Bearer " & token],
    response = Web.Contents(url, [Headers=headers]),
    data = Json.Document(response)
in
    data

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Hi, 

Thanks for your support. i tried using above code , still gettig the same error. . Please see the attached screenshots.  in the second script i just tried displaying the token value instead passing the value to retrieve the data.

Postman is generating the token and retrieving the data for the same credentials

for the same URL and