Forum Discussion
Anonymous
9 years agoNot applicable
Power BI Report web part for SharePoint Online Discussion
The new Power BI (preview) web part for SharePoint Online is now available globally for Office 365 First Release customers. The web part lets you securely embed Power BI reports from your PowerBI.com...
frankchen
8 years agoRegular Visitor
I finally figured out how to show a Power BI report on a SharePoint modern page, I basically tried the following options
- Use modern Power BI SPFx web part. this approach requires your viewer to have Power BI Pro license. if they don't, the page will popup a message and ask them to either get a license or start a trail. I found out this approach is same as you share the report to others via Power BI desktop application.
- Use embedded SPFx web part. To do this, you need to make sure your tenant admin allows you to publish Power BI report to a web. currently this configuration is available for Power BI tenant setting. it can be turn on for all tenant or specific groups. After your tenant admin enable that option, you will see a menu item called "Publish to web" availalbe on your Power BI -> File menu which allows you get a embedded code (iframe format html code). you can paste this code in the embedded SPFx web part or any web site which support embedded code via iframe. The good thing for this approach is the people who actually are gong to see the report from embedded don't need Power BI Pro license. The bad thing there is no security added on top of the embedded report which means anyone can see that report as long as they have that embedded code. You might be able to overcome that by using SharePoint page which allows you to add permission for the page. But underline, it didn't change the security of the embedded report. Please also see Publish to web from Power BI for more information.
Personally, I still think MS should allow non-license people to view the report. Can MS let us know if this is scope they are working on or there is UserVoice we can vote it? Having all viewers to have Pro license is not going to compete with other BI products out there.
Thanks