Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need some help calling API with body

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.

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Any help is appreciated btw 🙂

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    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.