Embedding Sharepoint List into Power BI with HTML visual and iframe

[ColinRE]

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! 

[Anonymous]

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

[ColinRE]

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. 

[Joe_Barry]

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