Get MS AAD access token

Anonymous — Fri, 20 May 2022 05:40:30 GMT

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.

Re: Get MS AAD access token

lbendlin — Sat, 21 May 2022 21:15:20 GMT

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

Re: Get MS AAD access token

sebMTW2022 — Tue, 08 Nov 2022 15:56:53 GMT

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

topic Re: Get MS AAD access token in Power Query

Get MS AAD access token

Re: Get MS AAD access token

Re: Get MS AAD access token