Solved: How to get EmbedToken Generated using PostMan ? HT...

Jamir · ‎09-22-2022

1. I was able to genrate Accesstoken using : (Works in postman)

POST - https://login.microsoftonline.com/{{tenant_id}}/oauth2/token

Header:

Content-Type application/x-www-form-urlencoded

Body:

grant_type: client_credentials

client_secret: {{client_secret}}

client_id: {{client_id}}

resource: https://analysis.windows.net/powerbi/api

(works fine)

2. Get EmbedToken (Does not work in postman):

I could get the EmbedToken using link below.

https://learn.microsoft.com/en-us/rest/api/power-bi/embed-token/datasets-generate-token-in-group

(for our prototype, we will not want to use above step)

Using Postman I have tried many different scenarios, it all fails

POST - https://api.powerbi.com/v1.0/myorg/groups/{{groupId}}/reports/{{reportId}}/GenerateToken

Header:

Authorization: Bearer {{temp_access_token}}

Host: <calculated when request is sent>

Content-Type: application/json

Body:

{

"accessLevel": "View",

"allowSaveAs": "false"

}

Result:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">

<HTML>

<HEAD>

<TITLE>Bad Request</TITLE>

</HEAD>

<BODY>

<h2>Bad Request - Invalid Hostname</h2>

<hr>

<p>HTTP Error 400. The request hostname is invalid.</p>

</BODY>

</HTML>

3. Get Embed URL (Does not work in postman)

This works:

https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group#code-try-0

(for our prototype, we will not want to use above step)

Using Postman

POST -https://api.powerbi.com/v1.0/myorg/groups/{{groupId}}/reports

Header:

Authorization: Bearer {{temp_access_token}}

Error:

{

"error": {

"code": "PowerBINotAuthorizedException",

"pbi.error": {

"code": "PowerBINotAuthorizedException",

"parameters": {},

"details": [],

"exceptionCulprit": 1

}

Jamir · ‎09-24-2022

Finally, I made it work.. Here are all the details:

(I beleive my problem was with setting up Service Principal properly)

1. Access Token: POST

Header

Body

2. Embed Token: POST

Header

Body

3. EmbedReportURL: GET

View solution in original post

Jamir · ‎09-24-2022

Finally, I made it work.. Here are all the details:

(I beleive my problem was with setting up Service Principal properly)

1. Access Token: POST

Header

Body

2. Embed Token: POST

Header

Body

3. EmbedReportURL: GET

Jamir · ‎09-23-2022

hello @Anonymous

Appreciate your response.

I did both, it still does not work, I get HTTP Error 400, The request hostname is invalid. Error.

Anonymous · ‎09-22-2022

Hello @Jamir ,

I had the same issue and adding these headers worked

URL: https://api.powerbi.com/v1.0/myorg/groups/d...c5/reports/da9.....3/GenerateToken

Body:

{

"accessLevel": "View",

"allowSaveAs": "false"

}

If it still doesn't work, click on run it in Embed Token - Reports GenerateTokenInGroup - REST API (Power BI Power BI REST APIs) | Microsoft Lear... add your group id, report id and copy paste the URl. It worked!

How to get EmbedToken Generated using PostMan ? HTTP Error 400. The request hostname is invalid.

Helpful resources

Power BI Monthly Update - November 2023

Fabric Community News unified experience

The largest Power BI and Fabric virtual conference