Forum Discussion

keith_smith1's avatar
keith_smith1
Advocate I
1 year ago
Solved

Sharepoint Embedded Paginated Report "Sign In" button does not work

Hello, I am trying to embed "PowerBI Report Builder" Paginated reports in Sharepoint.    If a Sharepoint user loads a page with an embedded paginated report, they see the following message:    ...
security
  • keith_smith1's avatar
    keith_smith1
    1 year ago

    v-prasare burakkaragoz andrewsommer Per Microsoft tech support, embedding PowerBI Report Builder reports (rdl) in Sharepoint is not supported.

     

    It works fine for one customer, doesn't work for the other! 

andrewsommer's avatar
andrewsommer
Super User
1 year ago

When you embed a Paginated Report into SharePoint Online (e.g., via iframe or Power BI web part), the authentication to Power BI Service must complete within the same browser context (iframe + session + token chain).
What you're seeing is:

  • Clicking "Sign in" inside the embedded report triggers a popup-based login (modern auth).
  • The popup authenticates the user and closes, but:
    • The parent page fails to detect that authentication completed, due to:
      • Blocked third-party cookies, or
      • SameSite cookie restrictions, or
      • Cross-origin iframe sandboxing, or
      • Recent Microsoft identity flow update (April–May 2025 updates hardened this).
  • Result: The iframe can’t reuse the token, and reloading doesn't help.

Recommended Fixes

  1. Enable Third-Party Cookies: Edge and Chrome have started enforcing third-party cookie restrictions that block Power BI iframe auth tokens.

In Edge:

  • Go to edge://settings/content/cookies
  • Allow all cookies
  • Or, add an exception for https://app.powerbi.com and your SharePoint domain

 

  1. Add Trusted Sites in Edge

Ensure both Power BI and SharePoint domains are in trusted sites:

  • Open Internet Options > Security > Trusted Sites > Sites
  • Add:
    • https://*.powerbi.com
    • https://*.microsoftonline.com
    • https://*.sharepoint.com

This helps the Microsoft Identity Platform maintain session integrity across domains.

 

  1. Enable "Allow Authentication Context" in SharePoint Embed

If embedding via iframe manually (i.e., not Power BI web part), ensure:

<iframe
  src="https://app.powerbi.com/reportEmbed?reportId=...&..."
  sandbox="allow-scripts allow-same-origin allow-forms allow-popups allow-popups-to-escape-sandbox"
  allow="fullscreen"
></iframe>

 

Please mark this post as a solution if it helps you. Appreciate Kudos.

 

keith_smith1's avatar
keith_smith1
Advocate I
1 year ago

andrewsommer Thank you for your suggestions.

 

I have:

  1. Added cookie exceptions for app.powerbi.com and our sharepoint site.
    • I can see I have two cookies from paginated-reports.powerbi.com 
  2. Added Trusted Sites you listed
  3. Updated my iFrame to include the details you listed

 

Unfortunately the issue persists!