Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Generating Token Dynamically from Power BI Desktop

I am trying to generate REST API token dynamically from Power BI Desktop, using power Query.   I am not sure what is causing this error. Any help is appreciated. An error occurred in the ‘’ query. D...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    After making few minor changes the code is generating token in Power BI . here is the modified code

    let
    GenerateToken = () =>
    let
    url = "https://login.mypurecloud.com.au/oauth/token",
    body = "grant_type=client_credentials&client_id=<client-id>&client_secret=<Clinet_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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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