topic Re: Power BI REST API using postman - generate embed token. in Developer

Power BI REST API using postman - generate embed token.

insoldev — Thu, 23 Nov 2017 20:31:49 GMT

Hello - currently working through trying to get an embed token using the Power BI rest api. I am following the guidance as on this page. https://msdn.microsoft.com/en-us/library/mt784614.aspx.

ultimately, I am trying to achieve the outcome of using javascript to host a Power BI report in the new model as per https://community.powerbi.com/t5/Developer/Embedding-without-hard-coding-master-credentials-app-owns-data/m-p/296611#M8734 as per @Eric_Zhang suggestion.

I am not getting an embed token - I am simply getting this response. Clearly I've missed something - I am using my client secret as the bearer token.

Re: Power BI REST API using postman - generate embed token.

Eric_Zhang — Fri, 24 Nov 2017 08:03:48 GMT

@insoldev wrote:

Hello - currently working through trying to get an embed token using the Power BI rest api. I am following the guidance as on this page. https://msdn.microsoft.com/en-us/library/mt784614.aspx.

ultimately, I am trying to achieve the outcome of using javascript to host a Power BI report in the new model as per https://community.powerbi.com/t5/Developer/Embedding-without-hard-coding-master-credentials-app-owns-data/m-p/296611#M8734 as per @Eric_Zhang suggestion.

I am not getting an embed token - I am simply getting this response. Clearly I've missed something - I am using my client secret as the bearer token.

@insoldev

The bearer token requires an access token, not the client secret. You need to follow this link to register a Native app rather than a server-side web app for Power BI Embedded cases and grant sufficient permissions.

Then to get the access token, you can call the POST API in POSTMAN as

POST /common/oauth2/token HTTP/1.1
Host: login.windows.net
Cache-Control: no-cache 
Content-Type: application/x-www-form-urlencoded

client_id={client id}&grant_type=password&resource=https%3A%2F%2Fanalysis.windows.net%2Fpowerbi%2Fapi&username={your power bi account}&password={your Power BI password}

With the above access_token, you can call the GenerateToken API.

By the way, using POSTMAN is recommended for testing/debug purpose, what would you like in your case?

Re: Power BI REST API using postman - generate embed token.

insoldev — Wed, 29 Nov 2017 10:58:47 GMT

Thanks for your response - I'm just testing to make sure I have the components working correctly.

Re: Power BI REST API using postman - generate embed token.

Yikun — Tue, 18 Sep 2018 11:37:36 GMT

First I would like to say sorry that I don't have an exact solution about this but I feel like that Whatever I will suggest here it would be helpful or it will work.

Just go through the article REST API in Power BI where all things are described in the wonderful and easy way. Diagrams and video are also available in this article which will help to learn in a more easier way.

Re: Power BI REST API using postman - generate embed token.

Yikun — Tue, 18 Sep 2018 11:45:22 GMT

First I would like to say sorry that I don't have an exact solution about this but I feel like that Whatever I will suggest here it would be helpful or it will work.

Hope it Helps 🙂

Re: Power BI REST API using postman - generate embed token.

insoldev — Wed, 19 Sep 2018 13:25:29 GMT

@Yikun, that isn't even close to relevant - I'm talking about using the Power BI API in an embedded application, not using an API as a data source in Power BI.

Re: Power BI REST API using postman - generate embed token.

insoldev — Wed, 19 Sep 2018 13:24:26 GMT

Hi @Eric_Zhang - I wanted to thank you for your contribution. This worked for me and gave me a really good steer. I have used Azure Functions apps to provide the server side functionality.

Re: Power BI REST API using postman - generate embed token.

Anonymous — Thu, 18 Oct 2018 20:24:47 GMT

I am getting this response from Postman:

"error": "invalid_grant", "error_description": "AADSTS70002: Error validating credentials. AADSTS50126: Invalid username or password\r\nTrace ID: c3c862a5-440b-43ba-a105-7efea28b2800\r\nCorrelation ID: 7df5b009-805a-4738-8c81-b9eca778054a\r\nTimestamp: 2018-10-18 20:14:11Z", "error_codes": [ 70002, 50126 ],

but I know my login/pw are good because if I use the same credentials/client_id with the Python library PyPowerBi (https://github.com/cmberryau/pypowerbi)

I can connect and make API calls, so the problem has to be with the Postman setup:

POST: https://login.microsoftonline.com/common/oauth2/token

BODY:

grant_type:password

client_id:{{client_id}}

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

scope:openid

username:{{username}}

password:{{password}}

Re: Power BI REST API using postman - generate embed token.

Anonymous — Thu, 06 Jun 2019 23:15:29 GMT

Thank you so much, was able to get the access_token using this method in postman.

When you say "With the above access_token, you can call the GenerateToken API.", can you give us an example of how we would use the access_token from the call to https://login.windows.net/common/oauth2/token to one of the post methods?

For example, I am trying to embed a report in .net core. I want to use this rest api method: Reports GenerateTokenInGroup

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

with some parameters (accessLevel, allowSaveAs, datasetId, identities) in the request body. How would I use the access_token from the first API call with the second one (POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/GenerateToken)?

Thank you!

Re: Power BI REST API using postman - generate embed token.

Oex — Wed, 22 Apr 2020 18:57:09 GMT

@Anonymous did you find a solution to this, are you able to share a common approach for postman?

Re: Power BI REST API using postman - generate embed token.

Jerry-Tang — Fri, 20 Jan 2023 14:34:28 GMT

Above solution only mentioned using Master User account to authenticate and get access token, in the request body we need provide username and password, Request URL is https://login.microsoftonline.com/common/oauth2/token. Actually we can use either https://login.microsoftonline.com/common/oauth2/token or https://login.microsoftonline.com/{tenantID}/oauth2/v2.0/token for master user.

Note: we need replace "{tenantID}" with cx tenant ID.

Furthermore, we can also use Service Principal to authenticate and get access token: the request URL can only be https://login.microsoftonline.com/{tenantID}/oauth2/v2.0/token

In the request body, we need set grant_type as client_credentials, and provide client_id and client_secret. After Create an Azure AD app, we will have Application ID(client_id) and secret.

Re: Power BI REST API using postman - generate embed token.

zmorlan — Fri, 27 Jan 2023 23:42:06 GMT

what is cx tenant ID

Re: Power BI REST API using postman - generate embed token.

Jerry-Tang — Sat, 28 Jan 2023 09:00:47 GMT

Re: How do you find the tenant ID? - Microsoft Community Hub

Re: Power BI REST API using postman - generate embed token.

Burhan_Jiru — Wed, 16 Aug 2023 14:59:50 GMT

Hi jerry,

I am trying the same in postman. but with this token I am not able to generate embed token in postman.

sharing response which I am getting when generating access token. can please confirm this is the correct response and you are getting the same.

If this is the correct response can you please guide me on how to generate embed token in Postman?

thank you

Re: Power BI REST API using postman - generate embed token.

arthurviana — Wed, 20 Sep 2023 16:24:23 GMT

Hello, I am getting the same error. Did you manage to make this work yet with client credentials?

Re: Power BI REST API using postman - generate embed token.

Anonymous — Fri, 22 Sep 2023 10:59:05 GMT

I'm facing some troubles in to replicate what has been done here.

I had already register the app on Azure AD and create the workspace in Power BI as mention here: Get started with Power BI Embedded - Power BI | Microsoft Learn

But when I use your steps to get access token by Postman, I receive that the hostname is not correct:

Can somebody help me please?

Re: Power BI REST API using postman - generate embed token.

gauravraj269 — Sun, 14 Apr 2024 05:54:49 GMT

Hey can anyone help me on this i already generate token for the same , but when i am using the same token to get power bi pipeline it through an error in power automate :

{"error":{"code":"ALM_InvalidRequest_AccessToPipelineDenied","pbi.error":{"code":"ALM_InvalidRequest_AccessToPipelineDenied","parameters":{},"details":[],"exceptionCulprit":1}}}

Tell me why , i already grant all the permissiion from azure AD

Re: Power BI REST API using postman - generate embed token.

chakri1431 — Tue, 14 May 2024 10:49:12 GMT

Hi, i am able to create access token but when i create workspace in powerbi its creating but its creating under service principle as admin, but when i create workspace with the token what i got from try it in microsoft its creating workspace under my name, how to get access token which creates workspace under my name as admin and not unser service principle. please give me an solution asap, thanks.