Forum Discussion

ColinRE's avatar
ColinRE
Icon for Helper I rankHelper I
2 years ago

Embedding Sharepoint List into Power BI with HTML visual and iframe

Hi Folks,

 

I want to add a SharePoint List list into a Power BI report using an HTML visual via an iframe. I can't tell if this considered cross scripting or Same-Origin Policy violation? The opposite is possible e.g. putting a Power BI report embedded into a SharePoint site. 

 

I got the refused to connect error. 

 

I was able to load my companies public home page in an iframe, but not simple things like Google.com

 

Goal is to allow data entry of a parametized Sharepoint list within the report. 

 

Ideas?

 

Thanks! 

Need Help

3 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hi ColinRE 

     

    Have you considered using the Power Apps visual in Power BI Desktop and have this write to the SharePoint list?

     

    •  

    • Add any measure to the Build section
    • Click on Create new

       

    • It will take you to Power Apps studio, here you can recreate the Form you have in SharePoint

       

    • On the right, click on add data and you can find your list here by choosing the SharePoint connector

       

    You can also create an app from within SharePoint and this will automatically create the connection and when you use the PowerApps Visual in Power BI, just choose existing app and choose your app

    Hope this helps

    Joe

  • ColinRE's avatar
    ColinRE
    Icon for Helper I rankHelper I
    2 years ago

    Hi Joe, 

    Trying to avoid Power Apps entirely, for a variety of reasons. For quick and simple things, Sharepoint List / forms. For things that need more controls and functionality, Power Apps. 

     

    Trying new things to see if the are possible. Thankls for your feedback though. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ColinRE ,

    Please review the following links, hope they can help you.

    Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn

    Embed a report in a secure portal or website - Power BI | Microsoft Learn

    • If your website sets the Cross-Origin-Opener-Policy (COOP) header to “same-origin,” you can't sign in to view your embedded content because MSAL doesn't support this header. Instead, choose either "restrict-properties" (for Chromium-based browsers) or "same-origin-allow-popups." Alternatively, if you can't change the Cross-Origin-Opener-Policy, link to the embedded URL directly instead of embedding it in an iframe.

    Best Regards