OAuth 2.0 Authorization Code flow grant type - Power Query API Connection

Hi Anonymous,

What type of error message displayed? Can you please share more detailed information?

How to Get Your Question Answered Quickly 

In addition, you can also try to add the 'relative path' option to your connector if it works:

let
    // PART 1: Get Authorization Code
    Body =
        "{'username':'<MyUsername>','password':'<MyPsw>','scope':['<SelectedScope>']}",
    url = "http://XXXXXXXXXXXXXXXXXXXXXXXXXXX/api/login/sso",
    GetJson =
        Json.Document(
            Web.Contents(
                url,
                [
                    Headers = [
                        ContentType = "application/json"
                    ],
                    Content = Text.ToBinary(Body)
                ]
            )
        ),
    AuthorizationCode = GetJson,
    // The previous code correctly returns the Authorization Code
    // PART 2: Now I try to Get Access Token passing the Authorization Code, the client_id and the client_secret
    // Base64 Encoding
    _client = "<client_id>:<client_secret>",
    TokenURL = "http://XXXXXXXX.XXXXXXXXXXX.com",
    Body2 =
        "{'grant_type': 'authorization_code','code': '"& AuthorizationCode& '" }",
    Source =
        Web.Contents(
            TokenURL,
            [
                Headers = [
                    ContentType = "application/json",
                    Authorization = "Basic " & Binary.ToText(Text.ToBinary(_client), BinaryEncoding.Base64)
                ],
                RelativePath="/oauth2/token/",
                Content = Text.ToBinary(Body2)
            ]
        )
in
    Source

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code Chris Webb's BI Blog (crossjoin.co.uk)

Regards,
Xiaoxin Sheng