Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to obtain a key from the server by placing a POST with basic auth. It works fine in Postman, but in PB Desktop it gives me:
DataSource.Error: Web.Contents with the Content option is only supported when connecting anonymously.
Here is my code:
let
url = "https://localhost:446/api/identity",
Source = Json.Document(Web.Contents(url, [Headers=[#"Content-Type"="application/x-www-form-urlencoded"],
Content = Text.ToBinary("{}")
]))
in
#"Source"
Is there a workaround or something?
Thanks
Solved! Go to Solution.
Hi @Markzolotoy
When you make POST requests in Power Query you must use Anonymous authentication when asked
then in the actual query you supply the username and password and the authentication is performed via the Headers of the POST request
let
url = "https://localhost:446/api/identity",
ClientID = "xxxxxxxx", // Username
Secret = "xxxxxxxx", //Password
EncodedCredentials = "Basic " & Binary.ToText(Text.ToBinary(ClientID & ":" & Secret), BinaryEncoding.Base64),
Source = Json.Document(Web.Contents(url,
[
Headers = [#"Content-Type"="application/x-www-form-urlencoded",#"Authorization"=EncodedCredentials],
Content=Text.ToBinary("grant_type=client_credentials")
]
)
)
in
Source
You may need to edit the Data source settings for this connection on your PC, to change it to Anonymous
regards
Phil
Proud to be a Super User!
Hi @Markzolotoy
When you make POST requests in Power Query you must use Anonymous authentication when asked
then in the actual query you supply the username and password and the authentication is performed via the Headers of the POST request
let
url = "https://localhost:446/api/identity",
ClientID = "xxxxxxxx", // Username
Secret = "xxxxxxxx", //Password
EncodedCredentials = "Basic " & Binary.ToText(Text.ToBinary(ClientID & ":" & Secret), BinaryEncoding.Base64),
Source = Json.Document(Web.Contents(url,
[
Headers = [#"Content-Type"="application/x-www-form-urlencoded",#"Authorization"=EncodedCredentials],
Content=Text.ToBinary("grant_type=client_credentials")
]
)
)
in
Source
You may need to edit the Data source settings for this connection on your PC, to change it to Anonymous
regards
Phil
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |