Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Jamir
Frequent Visitor

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

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>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii">
</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:
      (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
}
}
}
 
1 ACCEPTED SOLUTION
Jamir
Frequent Visitor

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

Jamir_0-1664062616546.png

Body

Jamir_1-1664062650858.png

 

2. Embed Token: POST

Header

Jamir_2-1664062696666.png

 

Body

Jamir_3-1664062724198.png

 

3. EmbedReportURL: GET

     

Jamir_4-1664062752331.png

 

View solution in original post

3 REPLIES 3
Jamir
Frequent Visitor

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

Jamir_0-1664062616546.png

Body

Jamir_1-1664062650858.png

 

2. Embed Token: POST

Header

Jamir_2-1664062696666.png

 

Body

Jamir_3-1664062724198.png

 

3. EmbedReportURL: GET

     

Jamir_4-1664062752331.png

 

Jamir
Frequent Visitor

hello @Anonymous 

 

Appreciate your response.

 

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

 

Jamir_0-1663951959886.png

 

Anonymous
Not applicable

Hello @Jamir ,

I had the same issue and adding these headers worked 

2022-09-23_11h16_59.png

 

URLhttps://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!

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.