Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
gilbertendaya
Helper IV
Helper IV

Get data using API post

Hello Guys,

 

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

how to get data.JPG

 

Thank you. 

5 REPLIES 5
PhilipTreacy
Super User
Super User

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.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Fowmy
Super User
Super User

@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

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Hi @Fowmy  But the Authorization is No Auth 😞 

Fowmy
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors