Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Marco_Iac
Frequent Visitor

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

Hi, i'm tryng to to get Access Token from an OAuth2 Authorization Code flow.

Here the code: "PART 1" work fine and return the Authorization Code, bat "PART 2" don't work and return error.

 

Thanks for help

 

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
a = "<client_id>" & ":" & "<client_secret>",
a2 = Text.ToBinary(a),
a3 = Binary.ToText(a2, BinaryEncoding.Base64),

TokenURL = "http://XXXXXXXXXXXXXXXXXXXXXXXXXXX/oauth2/token/",
Body2 =
"{
""grant_type"": ""authorization_code"",
""code"": """&AuthorizationCode&"""
}",

Source = Web.Contents(TokenURL, [Headers = [ContentType="application/json", Authorization = "Basic "&a3&""], Content = Text.ToBinary(Body2)])

in Source

 

1 ACCEPTED SOLUTION
Marco_Iac
Frequent Visitor

Solved, the problem was due to an erroneous Base64 Encoding

View solution in original post

2 REPLIES 2
Marco_Iac
Frequent Visitor

Solved, the problem was due to an erroneous Base64 Encoding

Anonymous
Not applicable

Hi @Marco_Iac,

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 An...

Regards,
Xiaoxin Sheng

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors