Forum Discussion
Using a POSTMAN request in PowerBI
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
3 Replies
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
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
I am able to retrieve access token using grant type 'client_credentials'. But when I call the GET datasets API, it gives 403 forbidden error even though I have assigned necessary permissions
