Using a POSTMAN request in PowerBI

[RainerBe]

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

[Swetha__Balu]

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

[RainerBe]

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

[MikeJohnsonZA]

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