Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
10 months ago
Solved

Single Sign On Power BI

Can it be possible to allow user redirect to Home Page of Power BI from third party Application after entering application credentials only one time?

  • Hi powerbiexpert22 ,
    Thank you for reaching out to Microsoft Fabric Community Forum.

    It’s possible for users to access the Power BI Home Page or specific reports directly from a third-party application after signing in just once by setting up Single Sign-On (SSO). This can be achieved through Azure AD (Microsoft Entra ID) by registering your third-party application and enabling authentication using OAuth 2.0 or OpenID Connect. Once users sign in through your application, Azure AD issues an ID token and an Access token that can also be used to access Power BI. Since Power BI operates under the same Azure AD tenant, users who already have an active session won’t be prompted to sign in again. You can simply redirect them to the Power BI Home Page at https://app.powerbi.com/home or to a specific report using a URL such as -https://app.powerbi.com/groups/{groupId}/reports/{reportId}. Alternatively, you can embed Power BI dashboards directly within your application by generating an Embed Token through the Power BI REST API, allowing users to interact with Power BI content seamlessly without needing to log in again. 

    Please note that a Power BI Pro or Premium license is required for users to access reports.

    After users sign in through Azure AD SSO, your app validates their tokens and redirects them to Power BI. Since Power BI detects the existing Azure AD session, users can access the Home Page or reports without needing to sign in again.

     

    For your reference, here are some  Microsoft documentation links that explain this setup in detail - 

    Embedding Power BI Content in Your Application

    Azure Active Directory Authentication

    Power BI REST API

     

2 Replies

  • Hi powerbiexpert22 ,

    As is often the case, the answer is "it depends".  If you are using the same AD (entra) then yes, that will work.  or, if you are passing authenticate to the browser, then yes that will work.

    You could build your own authentication flow as well where you add another thing, like Power Automate perhaps, in between the two.  

     

    All of these methods are outside the normal realm of this community but I am sure that you can search how to implement those things.

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support

    Hi powerbiexpert22 ,
    Thank you for reaching out to Microsoft Fabric Community Forum.

    It’s possible for users to access the Power BI Home Page or specific reports directly from a third-party application after signing in just once by setting up Single Sign-On (SSO). This can be achieved through Azure AD (Microsoft Entra ID) by registering your third-party application and enabling authentication using OAuth 2.0 or OpenID Connect. Once users sign in through your application, Azure AD issues an ID token and an Access token that can also be used to access Power BI. Since Power BI operates under the same Azure AD tenant, users who already have an active session won’t be prompted to sign in again. You can simply redirect them to the Power BI Home Page at https://app.powerbi.com/home or to a specific report using a URL such as -https://app.powerbi.com/groups/{groupId}/reports/{reportId}. Alternatively, you can embed Power BI dashboards directly within your application by generating an Embed Token through the Power BI REST API, allowing users to interact with Power BI content seamlessly without needing to log in again. 

    Please note that a Power BI Pro or Premium license is required for users to access reports.

    After users sign in through Azure AD SSO, your app validates their tokens and redirects them to Power BI. Since Power BI detects the existing Azure AD session, users can access the Home Page or reports without needing to sign in again.

     

    For your reference, here are some  Microsoft documentation links that explain this setup in detail - 

    Embedding Power BI Content in Your Application

    Azure Active Directory Authentication

    Power BI REST API