How to embed live powerbi report into a webui

[Anonymous]

I would like to embed a power bi report into an angular website and whenever the underlying data of the report changes (a database) i want it to be reflected in the webui automatically. There is no upper limit on how many times the data in the database will change.

Can some body please suggest what is the correct way to achieve it.

Is it mandatory to register the app with Azure to achieve it? if yes why? would like to understand the need from technical stand point.

[venal]

Please refer the below links.

https://docs.microsoft.com/en-us/power-bi/developer/embed-sample-for-customers

https://powerbi.microsoft.com/en-us/blog/easily-embed-secure-power-bi-reports-in-your-internal-porta...

If this post helps, then please consider Accept it as the solution to help the other members find it more

[Jayendran · Accepted solution]

Hi @Anonymous ,

Here is my suggestion

You can use the direct query to develop your report, using the direct query whenever you load the report it will try to pull the updated records from the database. 

There are two ways to achieve the powerbi embedded

1. Master Account (a master account that is a username and password to sign in to your Power BI Pro account)

2. Service Principal (app only token)

I'd recommend to go with the 2 approach (Modern Auth), eventually method 1 will be deprecated

In both the method it is mandatory to do the app registration. Because you have to call the PowerBI Embedded API, in order to call the API you have proper autentication. These proper autentication can be done only if you have done the proper app registration in your tenant.

As per the docs,

Spoiler

To access resources that secure an Azure AD tenant, the entity that requires access represents a security principal. This action holds true for both users (user principal) and applications (service principal).

The security principal defines the access policy and permissions for users and applications in the Azure AD tenant. This access policy enables core features such as authentication of users and applications during sign-in, and authorization during resource access. For more information, reference Application and service principal in Azure Active Directory (AAD).