Forum Discussion

mittalpatel130's avatar
mittalpatel130
Helper III
6 years ago

Power BI Secure Embed (User Owns Data) & Single Sign-on integration using JavaScript

Hello - 

 

We're using Power BI Premium Capacity and trying to embed Power BI Reports to ServiceNow Portal (JavaScript) and here is the scenario. 

 

  1. It is Secure Embed.
  2. It is for our Organization, so user owns data. 
  3. ServiceNow Portal uses the same Azure Active Directory as Power BI does.
  4. In this custom integration, we want to implement Single Sign-on so that users don't have to sign in again to view the reports while being on the ServiceNow Portal. 
  5. All custom code has to be JavaScript, because it will go with ServiceNow Portal Page. 

Is this possible using JavaScript? Here is what we've tried so far. 

  1. Created Azure AD Web App and got the ClientID and Client Secret.
  2. Get Azure AD Authorization Code using Web App - We're able to execute below URL and get the Authorization code in the URL. We couldn't find JavaScript code to generate this Authorization code using GET method.

    https://login.windows.net/common/oauth2/authorize?client_id=<<clientid>>&response_type=code&redirect_uri=<<redirecturi>>

  3. Successfully generated Bearer Access Token using Post API - https://login.microsoftonline.com/common/oauth2/token
  4. Once got the access token, we're able to embed the report using JavaScript. 

Can we please get any help on #2? 

 

Thank you.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

    did you find any way to do it? If so, Can you please share the process of embedding report on servicenow portal. I successfully got step 1,2,3. but unable to solve step 4. can I please get some help with step 4. If you have previously done it. 

     

    Thanks

    Niki

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello I am this at the moment with php but I do not know what to start with I have already done the azure ad configuration but I am missing more than coding I could have some help?