Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Guys,
Please advise on how to implement this in Power BI desktop?
Thank you.
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.
Proud to be a Super User!
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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 🙂
⭕ 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.