Power BI Embedded into External Applications – Part 2

| Analytics , Power BI ,

Power BI is one of the best platforms for data visualizations. Embedding Power BI reports and dashboards in other applications enables you to extend the capabilities of the platform and deliver more value to end users.

Now that we have seen how to embed the Power BI report using the RLS feature (check out our blog on Embedding a Power BI report using dynamic RLS), let’s see how we can integrate this report into external applications outside the Power BI service.  We have used a .net framework for integration and here’s a step by step process as to how we went about it:

Pre-Requisite

You will need the following:

Step 1:

Open Visual Studio and select “Open a project or Solution”.

open-project-visual-studio

Select “PowerBIEmbedded_AppOwnsData.sln” from the pop up window as shown below.

power-bi-embedded

 

Step 2:

Go to Properties,  select Webconfig.aspx file and replace the  “********” with the respective ID’s and save the file

powerbi-embedded

Step 3:

Open the Azure Portal and go to Azure AD Directory>Applications><App Name>>Authentications and enable the Access token and ID Tokens. Save the changes.

Note:
An Access Token is required to authenticate the Power BI service and an Embed Token identifies the available resources, duration of access, RLS, etc. The Embed Token will expire when the Access Token expires.

power-bi-embedded-rls-authentication

Step 4:
Go back to Visual Studio and execute the application. The application opens up in the browser. Enter your user details and the Role you had mentioned in your dashboard while assigning Dynamic Row Level Security.

Now you are ready to start embedding the Power BI assets to your Enterprise BI Portal or other external applications. To know more about embedding Power BI visualizations, get in touch with us today!

Share with: