Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey all,
I'm new to in coding and Im attemping to migrate a functioning post request from postman to PBI.
I can generate the code in a variety of languages from postman and am wondering what's the easiest way to
copy and paste this code into PBI in order to run the POST request from PBI directly.
Here's an example of the code in HTTP:
POST mypath HTTP/1.1
Host: myhost
Content-Type: application/json
Accept: */*
Cache-Control: no-cache
accept-encoding: gzip, deflate
Connection: keep-alive
cache-control: no-cache
{
"request":
{
"username": "myusername",
"password": mypassword"
}
}
The request delivers the following result
{
"subscribeResult": {
"expires": "2021-09-18T07:10:21.000Z",
"sessionId": "mysessionid",
"username": "myusername"
}
}
Has anyone an idea how can implement this kind of request in PowerBI?
Thanks in advance
Bernd
Thanks for the quick answer, but in your Link (Chris Webb) he explais, that PowerBI has some limitations. Especially POST request can only be done with anonymous authentication 😞 seeand hear https://www.youtube.com/watch?v=a0FqNLI0VsQ&t=1192s
I think that is the reason/limitation for my problem.
Nevertheless thanks for clearifiying.
BR Bernd
Hi
You can use [web] data source in Power BI to connect to a REST API. its probably easiest to do it in the power query advanced editor.
The function you will want to use Web.Contents - PowerQuery M | Microsoft Docs
this will allow you to make a call to the endpoint and specify the custom header.
For a full overview on how to do this there is a video that covers most of what you will need to know Accessing API and web service data using Power Query - by Chris Webb - YouTube
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |