Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Get MS AAD access token

I am trying to get a Microsoft AAD access token using a Power Query:

 

 

let
     url = "https://login.microsoftonline.com/<tenant_id>/oauth2/v2.0/token",
    
     body  = "{ ""client_id"": ""<client_id>"",  ""client_secret"": ""<client_secret>"", ""grant_type"": ""client_credentials"", ""scope"":""<scope>""}",
     options = [Headers = [#"Content-Type"="application/x-www-form-urlencoded"], Content = Text.ToBinary(body)],
     tokenResponse = Json.Document(Web.Contents(url,options)),
     AccessToken = tokenResponse[access_token],
     AccessTokenHeader = "Bearer " & AccessToken
 in
     AccessTokenHeader

 

 

 

I get the following error:

DataSource.Error: Fehler beim Abrufen von Inhalten von "https://login.microsoftonline.com/****************/oauth2/v2.0/token" (400) durch "Web.Contents": Bad Request

Need help please, can't find anything on the web.

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    According to Chris Webb this will only work in custom connectors.

  • sebMTW2022's avatar
    sebMTW2022
    New Member
    3 years ago

    I've the same issue , it works with another api with oauth2  for another system but not for microsoftlogin whereas it works in postman...