It is simple to embed Power BI Reports and Dashboards into your web application since Power BI provides a simple framework to implement the embed code to your web application. This is specifically relevant to Independent Service Vendors (ISVs).we can restrict the functionalities on a more granular level, add more filters that are not available in the actual report, hide specific visuals, and even change the layout of the visuals in the report.
There are three methods to embed Power BI Reports.
- Publish to Web.
- Power BI Embedded for your Organization – User Owns Data
- Power BI Embedded for Customers – App Owns Data
I would like to explain about Power Bi Embedded for your Organization which is also called User Owns Data.The security settings (including row-level security) for the Power BI Reports is carried over and user requires the individual application to log in before viewing the embedded reports.This method is secure your data.To implement user owns data we need to follow below steps
Step 1: Go to the Link https://app.powerbi.com/embedsetup and click on embed for your organization
Once click on embed for your organization it will redirect to next page where you have to login with your power bi service account (i.e Power bi pro or Premium license).
Step 2: Once you logged in,you will get the ‘Next’ Button along with your user name and email.Click on ‘Next’ button and Register your Application with Azure AD.
Provide Application name as per business requirement then provide home page url which is nothing but your web application url where the reports need to be embedded.I am using the localhost url here.
Select first option that is ‘Use a default URL’ under the Redirect url option.Select all in API Access option or you can select as per your requirement whatever API access option you needed for embedding the report.
After clicking on Register,we will get the Application ID and Application Secret.
If you already have the workspace and the reports ready in Power BI, you can skip Step 3 and 4 else you can create workspace and import report in it.
In this case we already have the workspace and the reports ready in Power BI services.
The Web Application is now registered on Azure, and we can embed Power BI content in it. Please save the Application ID and Application secret, because we would be using it in our application.
Step 3: I am configuring the sample application provided and embed a Power BI Report in it.you can use your application to configure for embedding a Power BI Report.
The sample Power BI Application can be downloaded using the Download Sample App button. It is also available at the link below.
https://github.com/Microsoft/PowerBI-Developer-Samples/tree/master
In the downloaded application files, open the Cloud.config file, and update the Application ID and Application Secret fields in it.
Go to Power Bi service and open your Workspace where you import your report then in URL we get Workspace ID and the Report ID.you can copy these value from the URL same as shown below in screenshot
Update the Workspace ID and the Report ID fields with the values of the Power BI Report you wish to embed.
Step 4: Running the Application. Once you run the application it will show the result on browser. Here you will get the option for Embed Report.Just click on Embed Report button.
Once you click on Embed Report button it will redirect to another page where you have to click on Get Report Button
After click on Get Report button it will ask for permission where user needs to sign in which is nothing but the concept of User Owns Data.You have to check the box and Accept the consent on behalf of your organization.
Once you logged in and Accept the consent on behalf of your organization,you will see the embedded report on your application else your not able to see the Report.
Thank You,
Prashant Tonk
Helical IT Solutions
Best Open Source Business Intelligence Software Helical Insight is Here
