topic Re: How To: Get embed token using Get/Post only in Developer

How To: Get embed token using Get/Post only

adamwallace3 — Thu, 02 Nov 2017 13:55:49 GMT

Step 1: Authorize App

I used a native app, it was the simplest solution. You can use a server-web app, but you will need to add client_secret anywhere you see client_id in this walkthrough. You will need to at least have read permissions enabled.

Step 2: Get Access Token (post)

POST: https://login.microsoftonline.com/common/oauth2/token
data: {
    grant_type: password
    scope: openid
    resource: https://analysis.windows.net/powerbi/api
    client_id: {Client ID}
    username: {PBI Account Username}
    password: {PBI Account Username}
}

--Returns Json:
 
{
    "token_type": "Bearer",
    "scope": "Report.Read.All ...",
    "expires_in": "xxxx",
    "ext_expires_in": "0",
    "expires_on": "xxxxxxxxxx",
    "not_before": "xxxxxxxxxxx",
    "resource": "https://analysis.windows.net/powerbi/api",
    "access_token": "eyJ0eXAi...",
    "refresh_token": "AQABA...",
    "id_token": "eyJ...."
}

Step 3: Get Report details:

This can be done two different ways. The simplest way is to navigate to your report on the Power Bi website and pull the report id and group id from the url.

https://app.powerbi.com/groups/{GROUP ID}/reports/{REPORT ID}/ReportSection

I needed to pull different reports from a given group, so here is the get request to do that.

GET https://api.powerbi.com/v1.0/myorg/groups/{GROUP ID}/reports
headers = {
Authorization: Bearer + {access_token from first post}
}

Returns Json:
{
    "@odata.context": "http://wabi-west-us-redirect.analysis.windows.net/v1.0/myorg/groups/.../$metadata#reports",
    "value": [
        {
            "id": "...",
            "modelId": 0,
            "name": "...",
            "webUrl": "...",
            "embedUrl": "https://app.powerbi.com/reportEmbed?reportId={REPORT ID}&groupId={GROUP ID}",
            "isOwnedByMe": true,
            "isOriginalPbixReport": false,
            "datasetId": "..."
        },
... Repeated for other Reports in Group
}

Step 4: Get Embed token

In the old Power Bi server (through Azure) you could encode your own embed token, in the September 2017 update Microsoft started to require that you use the rest api or one of the available SDKs. In the "data" section you can pass arguments to implement row level security (link).

POST https://api.powerbi.com/v1.0/myorg/groups/{GROUP ID}/reports/{REPORT ID}/GenerateToken
headers = {
Authorization: Bearer + {access_token from first post}
Content-Type:application/json; charset=utf-8
Accept:application/json
}
data= {
  "accessLevel": "View",
  "allowSaveAs": "false"
}

Returns Json:
{
    "@odata.context": "http://wabi-west-us-redirect.analysis.windows.net/v1.0/myorg/groups/{GROUP_ID}/$metadata#Microsoft.PowerBI.ServiceContracts.Api.V1.GenerateTokenResponse",
    "token": "H4sIAAAAAAA...",
    "tokenId": "...",
    "expiration": "yyyy-mm-ddTxx:xxxxx"
}

Step 5: Test

Go to the Microsoft Power BI Embedded Sample site (link) and test your report.

The input fields are as follows:

Embed Token: {token from final post}
Embed URL: https://app.powerbi.com/reportEmbed?reportId={REPORT ID}&groupId={GROUP ID}
Report Id: {REPORT ID}

You can also test the embedded report using the following :

<html>
<script src="https://microsoft.github.io/PowerBI-JavaScript/demo/node_modules/jquery/dist/jquery.js"></script>
<script src="https://microsoft.github.io/PowerBI-JavaScript/demo/node_modules/powerbi-client/dist/powerbi.js"></script>
<script type="text/javascript">

window.onload = function () {
var embedConfiguration = {
    type: 'report',
	accessToken: '{access_token}',
	embedUrl: 'https://app.powerbi.com/reportEmbed?reportId={REPORT ID}&groupId={GROUP ID}',
	id:'{REPORT ID}',
settings: {
              {settings_ from link}
            }
	}; 
var $reportContainer = $('#dashboardContainer');
var report = powerbi.embed($reportContainer.get(0), embedConfiguration);
}

function reloadreport(){
	var element = $('#dashboardContainer');
	alert(element);
	var report = powerbi.get(element);
	report.reload().catch(error => {console.log(error)  });
};
</script> 
<div id="dashboardContainer"></div>
</html>

Notes:

Available settings can be found here.

Disclaimer:

This code comes with no warranty and no guarantees. It is HIGHLY likely that Microsoft will change something and this walkthrough will become depreciated. Please check your PowerBi agreement to make sure that the steps listed in this walkthrough adhere to the agreed upon terms.

Tags:

Python, embedded, token, access token, get, post, REST API, ruby, PHP

EDIT 1:

Added space to prevent 😮 and 😛 in code.

Edit 2:

Turned down sarcasm and added links.

Re: How To: Get embed token using Get/Post only

Eric_Zhang — Thu, 02 Nov 2017 05:45:44 GMT

@adamwallace3

Thanks for your sharing. It really helps.

Re: How To: Get embed token using Get/Post only

unnie — Tue, 27 Mar 2018 17:33:37 GMT

I tried with native app approach and it works when I use UserCredentials (username & password). But if I use a web app and use client id , client secret it always says unauthorised. Is there a limitation that PowerBI APIs only works with user credentials?

Re: How To: Get embed token using Get/Post only

Anonymous — Mon, 02 Apr 2018 19:17:22 GMT

I am able to follow thorugh until the last step. When I use the HTML code with the Javascript nothing happens. I am able to perform all the following steps and obtain all the needed information. I am also able to input my token information into the sample website linked in the post and my report loads.

This is in a simple angular app. What do I need to do after I have my embeded token in order to display the ebmedded report?

Re: How To: Get embed token using Get/Post only

andyparkerson — Wed, 18 Apr 2018 19:31:51 GMT

This has been a great help, as I am in a PHP shop, and all of the examples on the Power BI Developer site are in C#.

Thanks so much.

Re: How To: Get embed token using Get/Post only

nitin_sp — Tue, 01 May 2018 06:24:20 GMT

Hi there,

You need to pass the PowerBI credential because that is how the licensing model of Power BI works. That was MS can satisfy that the user who is trying to embed report is Power BI Pro user and that has the Power Bi Embedded capaciy.

Re: How To: Get embed token using Get/Post only

azulcore — Wed, 13 Jun 2018 17:41:09 GMT

Thanks for sharing and sorry for the novice question but how and where can I run this code?

Re: How To: Get embed token using Get/Post only

andyparkerson — Wed, 13 Jun 2018 17:53:21 GMT

This isn't code, but rather pseudocode. You would need to implement it in whatever language you are writing in.

The best thing to do is probably try Postman, at https://www.getpostman.com/. You can use that to send GET/POST commands to the API.

Re: How To: Get embed token using Get/Post only

azulcore — Wed, 13 Jun 2018 18:13:37 GMT

Thank you! I was able to run it!

Re: How To: Get embed token using Get/Post only

azulcore — Thu, 14 Jun 2018 14:16:01 GMT

Steps 1 and 2 run as expected, when I run step 3 & 4 it just returns blank, any ideas?

Sorry, I am using Postman and I added the quotes around the token, once I removed the quotes it worked fine.

Re: How To: Get embed token using Get/Post only

azulcore — Fri, 15 Jun 2018 21:38:58 GMT

All of the steps work except for the last step. I entered all the values in the https://microsoft.github.io/PowerBI-JavaScript/demo and it works well. But using your html code at the end just gives a blank page, any ideas? I use clientid and clientsecret if that makes a difference

Re: How To: Get embed token using Get/Post only

ashleymartin — Wed, 20 Jun 2018 22:12:13 GMT

Step 4 is not working for me. I was able to get the access token in step 2 and then able to run step 3. For step 4 I entered the header information into postman under header and the data information under the body but I am getting this error:

{
"error": {
"code": "BadRequest",
"message": "Bad Request",
"details": [
{
"message": "Unexpected character encountered while parsing number: W. Path '', line 1, position 6.",
"target": "request"
}
]
}
}
]
}
}

Is anyone else experiencing this or know of a way I can fix this? Also for reference I am doing a server-web app and have added the client secret into the first step, not sure if I would need to add anything in this 4th step too or if there is another reason it is showing this error.

Re: How To: Get embed token using Get/Post only

matthewgouws — Wed, 11 Jul 2018 09:27:05 GMT

Hi,

Did you find the solution to the error you were getting in Step 4 ?

Thanks in advance!

Re: How To: Get embed token using Get/Post only

matthewgouws — Wed, 11 Jul 2018 09:30:32 GMT

Hi,

Did you manage to find a solution to the error you were getting in step 4 of this guide?

Regards,

Matt

Re: How To: Get embed token using Get/Post only

zachmiller — Thu, 12 Jul 2018 19:24:51 GMT

@ashleymartin The "data= {}" section of step 4 needs to be put into the "Body" tab on Postman. You can click the "raw" radio button to be able to paste it in directly. The headers go in the headers tab as well. Other than that, make sure that the access token you have is not expired. From there, you can use the embed token where ever you deem appropriate.

Re: How To: Get embed token using Get/Post only

riyanka — Fri, 20 Jul 2018 12:57:48 GMT

could you please send screenshot of step no 2 in postman

Re: How To: Get embed token using Get/Post only

zachmiller — Tue, 24 Jul 2018 20:14:35 GMT

Here's how Step 2 should be set up in Postman, keeping in mind that I obviously censored the 4 empty values.

Re: How To: Get embed token using Get/Post only

aaco — Thu, 26 Jul 2018 12:15:44 GMT

Hi,

When executing the step 4 in Postman (adding the Authorization token in the headers and the Data in the body) I'm getting the following error:

{
"error": {
"code": "",
"message": "The request entity's media type 'multipart/form-data' is not supported for this resource."
}
}

Also, when running step 5 in Chrome, I get this error message:

GET https://wabi-north-europe-redirect.analysis.windows.net/metadata/cluster 403 (Forbidden)

From step 1 to step 3 all works as described. Is someone else getting the same error message? Any ideas of how to fix it or where it should be coming from?

Many thanks

Re: How To: Get embed token using Get/Post only

aaco — Thu, 26 Jul 2018 13:03:23 GMT

So, I figured out that I wasn't using the Body > raw > JSON (application/json) option in Postman. Now I do it but am getting a different error:

{
"error": {
"code": "Unauthorized",
"message": "Report.Read.All Dataset.Read.All"
}
}

For info, steps 1 to 3 are still OK and permissions on the Azure App Registration side for 'Power BI Service' are all set to 'DELEGATED' (19 in total).

Thanks again.

Re: How To: Get embed token using Get/Post only

d_u_a — Tue, 31 Jul 2018 06:30:47 GMT

@adamwallace3 I'm sending Post request with like in your first step. But getting this error :

"error": "invalid_request",
"error_description": "AADSTS90014: The request body must contain the following parameter: 'grant_type'.\r\

My App type is web/api in azure . Is there a solution to fix this grant_type issue?