Ways For Using Power BI Embedded In Apps And Websites

  • Post category:General
  • Post author:

Power BI Embedded on a Microsoft Azure’s Platform-as-a-Service (PaaS) solution provides a series of interfaces to facilitate the incorporation of Power BI content into customised applications and websites.

You can use all the features, such as cross-filtering, Row Level Protection, and Q&A. Standard Power BI Desktop can also be used to build reports, and you are no longer limited to posting your reports to the Power BI service. Additionally, Power BI Embedded helps you to incorporate it into your own web and mobile apps— Not only for the company but also third parties users. The latter doesn’t even need a Power BI licence, but instead, they can use their own authentication scheme that can be combined with Power BI Embedded powerful API.

Some people will recognise this as a Power BI Workspace Collection. However, this Azure service was discontinued in June 2018 with Power BI Embedded becoming as its successor. Microsoft even started to address Workspace Collections as “Embedded Version 1”. Back then, the functionality was very limited—e. g. Just two data connectors, no bookmarks, no Q&A—and a designated API. Power BI embedded is now closely related to the well-known Power BI, providing the same functionality and utilising the same API.

Available capacities

Power BI embedded Capacity is described in the SKUs, the A-SKU, the EM-SKU and the P-SKU. All of these are divided into multiple types of nodes with different peak rendering capability (page refresh, filtering, slicing/cutting) per hour.

Creating an application with an embedded Power BI report

Microsoft power BI partners use the following terms when it comes to using embed power bi dashboard

  • ‘App owns data.’
  • ‘User owns data.’

The key difference is that ‘User owns data’ implies that any customer must have a Power BI licence. However, this is typically not true when you want to send Power BI reports to your customers. So we’re going to concentrate on using the ‘App owns data’ example.

Setup of the Power BI and Azure Ecosystem

Let’s assume that you have mastered the ability to integrate your Power BI data.   What are you supposed to do next to embed power bi dashboard report? The obvious first step is to build a report that you would like to embed. You can use Power BI Desktop for this and use any features you like such as Row-Level Protection, custom graphics or bookmarks.

You then need to set up an environment to incorporate this report to your custom app. Luckily, you can use a wizard to do this, which will lead you through every step needed to prepare for Power BI implementation.

Setting up Application

Let’s just presume that you already have a decent app for your clients or colleagues to use. Or you’re going to create it from scratch, but you know how to do it. All you want to do is include the content you generated in Power BI implementation. 

Depending on the technologies used, you can either integrate the.NET SDK, the JavaScript API or, go with the most generic approach, the Power BI Rest API.