Need some help calling API with body

[SteffH]

so i have an API link to get data, it requires simply a post command with the api link and some body information

the body info is as followed:

This works fine in Postman and I get the data in JSON format, but im curious how i can do the same in Power BI. Any help is appreciated 🙂

Also a second thing would be to make a script to receive the access token

It's a simple Post login link where the body is as follows:

So the password and username and domain is given in the body, not in the authorization tab in Postman.

[v-jianboli-msft · Accepted solution]

Hi @SteffH ,

While the Power Query Web.Contents() function generates a GET request by default, you can make it generate a POST request by specifying the Content option.

For more details, please refer to:

Web.Contents - PowerQuery M | Microsoft Learn 

Chris Webb's BI Blog: Web Services And POST Requests In Power Query 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jianboli-msft]

Hi @SteffH ,

Based on your description, I will use Datasets - Get Dataset In Group  API as an example:

let
//Get API Token
  tokenapiUrl = "https://login.microsoftonline.com/ecxxxxxxxx/oauth2/v2.0/token",
    body = [
          client_id="d32xxxxxx",
          grant_type="client_credentials",
          client_secret="vMfxxxxxx",
          scope="https://analysis.windows.net/powerbi/api/.default"
],

API_Response = Json.Document(Web.Contents(tokenapiUrl, [Headers = [Accept = "application/json"],
Content = Text.ToBinary(Uri.BuildQueryString(body))])),
token = API_Response[access_token],
//Get Data
apiUrl = "https://api.powerbi.com/v1.0/myorg/groups/476xxxxxxx/datasets/3a7xxxxxx",
data  = Json.Document(Web.Contents(apiUrl,[Headers=[#"Authorization"="Bearer "&token,#"Content-Type"="application/json"]]))
in
data

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SteffH]

Hi Jianboli,

First of all thanks for the detailed answer, however i think I'm running into one problem, the following things are given in the body of the getData call (not in the headers):

- access_token=

- version= (9.5 for example)

- images= (0 for example)

I'm dealing with a POST request, not a get request, and these parameters will not work when given as a header, but only when given in the body.

[SteffH]

Any help is appreciated btw 🙂