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.
Hi ,
How to generate API access token dynamically using refresh token or basic auth (username and passowrd)
I tried to generate access token dynamically but failed with the below.
let
url ="https://testapi.apples.com/api/v1/auth",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([username="username",
password= "password"]),
response = Web.Contents(
url,
[
Headers = headers,
Content = postData
]
),
access_token = Json.Document(response)
in
access_token
Error:
DataSource.Error: Web.Contents failed to get contents from 'https://testapi.apples.com/api/v1/auth' (400): Bad Request
Details:
DataSourceKind=Web
DataSourcePath=https://testapi.apples.com/api/v1/auth
Url=https://testapi.apples.com/api/v1/auth
Any suggestions would be much appriciated.
Many thanks
Solved! Go to Solution.
@venusura483 , refer if these can help
https://www.advaiya.com/generate-dynamic-token-and-get-data-from-custom-api-in-power-bi/
@amitchandak , It is resolved with https://community.fabric.microsoft.com/t5/Power-Query/Channel-Advisor-API-Connection-with-auth-key-c...
Thank you.
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |