Forum Discussion

Gautam_Sharma's avatar
Gautam_Sharma
Frequent Visitor
2 years ago
Solved

Access PowerBI Report - when users having multiple Microsoft account from different Org

Hi Team, We have published several PowerBI reports accessible to all authenticated users within our web application via an iframe, with a total user base of over 60,000. Everything works well beca...
@PowerBI Report Server
APIS and Embedding
Embedded power Bi server reports into Website
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Gautam_Sharma ,

    You must grant the service principal ReadOverrideEffectiveIdentity permission. Otherwise, the service principal can’t delegate the user identity to the gateway.

    The following link will help you:

    Power BI Embedded, Service Principals, and SSAS – Prologika

    Best Regards,

    Xianda Tang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Gautam_Sharma ,

I recommend considering the "embed for customers" scenario and for service principal authentication. This method allows you to embed Power BI content for users without requiring them to have a Power BI account or sign in to a Microsoft account.

The whole step is pretty much the same as you said.

Use the service principal to get an access token from Azure AD. This token is then used to authenticate API requests to Power BI in order to embed the report. This process ensures that the access token isn't exposed at the UI layer.

Below is the official link will help you:
Embed Power BI content in an embedded analytics application with service principal and an application secret - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

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