Get data using API post

[gilbertendaya]

Hello Guys,

Please advise on how to implement this in Power BI desktop?

Thank you. 

[PhilipTreacy]

Hi @gilbertendaya 

To make a POST request in PBI/PQ you include Content in the request.  A typical POST request would look something like this

let
    URL = "https://API.com/XXXX",
    TheContent = "xxx",

    Options = 

            [
                Headers = [ #"Content-Type"="application/json" ], #"Accept-Encoding"="gzip, deflate", Content = Text.ToBinary(TheContent)    
            ],  

        Result = Web.Contents(URL, Options)

    in
        Result

You've said the connection requires no auth so when PQ/PBI asks you how to connect, you need to choose Anonymous connection.

That said, the Postman screenshot shows an X-Auth-Token so it looks like there is some kind of authorization going on.

Without more info from you on the API and what exactly you are trying to do,I can't bemore specific with my answer.

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Fowmy]

@gilbertendaya 

Check this post please:

https://dataveld.com/2020/05/09/using-postman-with-the-power-bi-rest-api/
https://community.powerbi.com/t5/Desktop/Connect-to-a-Web-Service-sending-parameters/td-p/225510

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[gilbertendaya]

Hi @Fowmy  But the Authorization is No Auth 😞 

[Fowmy]

@gilbertendaya 

Not enough information to understand your question, anyhow, please refer this article: https://www.mssqltips.com/sqlservertip/6318/read-api-data-with-power-bi-using-power-query/

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[gilbertendaya]

Hello @Fowmy  Sorry for not elaborating my question.

The screenshot is in postman and it is using a Post method with those headers. 
Authorization is No Auth.

How can I implement this in power BI desktop?

I checked the link that you've provided but it is a GET method.