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,
I am having issues doing a POST method in M to grab an authentication token.
Specifically I am trying to grab data out of the REST API to Power Query for Excel..
They have given a piece of curl code, but I am having trouble dissecting it into M.
curl -X POST --user {user}:'{password}' https://auth.anaplan.com/token/authenticate
Any help would be appreciated
Hi @dcoronno ,
You could try this
Get Access token in Power BI Desktop:
() =>
let
body = "client_id=" & #"App ID"
& "&scope=https://analysis.windows.net/powerbi/api/.default&client_secret=" & #"App Secret"
& "&grant_type=client_credentials",
Data= Json.Document(Web.Contents("https://login.microsoftonline.com/"& TenantID & "/oauth2/v2.0/token/",
[Headers=[#"Content-Type"="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)])),
access_token = Data[access_token]
in
access_token
This is the official document you can refer to.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I was fighting with retrieving authentication tokens for some time. Here's what worked in my situation. The following is a function to retrieve an Auth Token which i then call in several different data queries. You may need to change the content type. Hope you can make it work for you!
let
Source = () =>
let
body = "{
""user"": ""UserHere"",
""pass"": ""PassHere""
}",
Data=Json.Document(Web.Contents("https://LinkHere", [Headers=[#"Content-Type"="application/json"], Content=Text.ToBinary(body)])),
access_token = Data[token]
in
access_token
in
Source
cheers,
Keith
You call Web.Contents with a Content payload to transform a GET call into a POST call.
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.