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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mittalpatel130
Helper III
Helper III

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...>>

  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 3
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 

 

Here is the playgroud I used to test my embed reports and copy paste the javascript for embedding in ServiceNow.

 

https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html

 

Let me know if this works for you. 

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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.