Forum Discussion

ysapiyev's avatar
ysapiyev
Icon for Responsive Resident rankResponsive Resident
7 years ago
Solved

Get token of report

Hi everyone   I have a question regarding embed token of report to insert it in Azure web app. Currently, I followed video instruction from Guy in cube regarding getting token and I got error. Al...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Yerkhan,

     

    Regarding the error, please refer to #grant-admin-consent-to-enterprise-apps-in-the-azure-portal for a solution. Please also refer to the snapshot below.

    Get-token-of-report

     

    In order to get the embed token, we need to get a valid access token first, then invoke the REST API with it to get the embed token. Please refer to the snapshots below.

    1. Get an access token.

    POST https://login.microsoftonline.com/replace_with_your_tenant_id/oauth2/token
    resource: https://analysis.windows.net/powerbi/api

    Get-token-of-report2

    2. Invoke the "generate embed token" API.

    Get-token-of-report3

    If there aren't any roles, you don't need to specify the identities.

     

    Best Regards,
    Dale

NEbdf's avatar
NEbdf
Frequent Visitor
7 years ago

Greetings,

first of all, thanks for the detailed instructions v-jiascu-msft. But I am still struggling to get this to work in Postman. I followed each of your described steps, but only get the following error message in return:

{
    "error": "invalid_grant",
    "error_description": "AADSTS70002: Error validating credentials. AADSTS50126: Invalid username or password\r\nTrace ID: dba5dbef-834c-4df0-910f-2ad7e6e23600\r\nCorrelation ID: ee8fa976-7366-4056-9523-b5d1c606c78f\r\nTimestamp: 2019-01-09 08:14:06Z",
    "error_codes": [
        70002,
        50126
    ],
    "timestamp": "2019-01-09 08:14:06Z",
    "trace_id": "dba5dbef-834c-4df0-910f-2ad7e6e23600",
    "correlation_id": "ee8fa976-7366-4056-9523-b5d1c606c78f"
}

I of course double checked every key/value, URL and the App Settings in Azure. I also used the PowerBI embed configuration tool to setup the environment in Azure. The generated .net application also generates a token sucessfully (but I need it with a simple post call) so I am sure that the used credentials are working.

Do you maybe have some more ideas what else I can try? Or are there maybe basic configurations in Azure which could prevent a successful post call of Postman?

Thanks!

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi NEbdf,

     

    Since you can use the password to get token with .net application, that's hard to say what went wrong. Can you share a snapshot of how you did it? Please mask the sensitive parts.

     

    Best Regards,
    Dale

    • NEbdf's avatar
      NEbdf
      Frequent Visitor
      7 years ago

      Sure. Here is the latest Postman configuration:

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi NEbdf,

         

        All seems good. If it's a web app, the client_secret is needed. But the error message shouldn't be this one. 

        If I use a wrong password, I got the same error message. I would suggest you check the username and password again though it sounds impossible. Maybe you have multi-tenant?

         

        Best Regards,
        Dale