Embedding Power BI into SharePoint

[Anonymous]

Hello,

I want to ask for your experience, if you have used the option to embed Power BI report into SharePoint.

We need to decide how to distribute the Power BI reports to other colleagues within the company:
- Sharing only via the app version (using WorkSpace Power BI Premium, which we have bought)
- Embed all reports into SharePoint (where we store all other information) so that we can have one-stop shop for users.

Have you use SharePoint for Power BI report distribution? What do you think is the advantages/disadvantages of that? Any advice/recommendation?

Thank you very much!

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

In my opinion, the feature integrating Power BI reports in SharePoint Online can include Power BI content easily. And it enables SharePoint authors to embed Power BI reports directly in SharePoint Online pages with no code required.

While The Power BI report web part requires all the viewers to have a Power BI Pro license. If your users don’t have a Pro license, they’ll be directed to PowerBI.com where they can enroll or start a Pro trial.  You’ll see the web part if your Office 365 tenant administrator opted-in to the First Release program. If they didn’t or you’re not one of the users selected to receive First Release updates, then the web part will not appear in the list of web parts available to you. 

If some colleagues don't have pro license, it's good share the dashbord/report via app version. Because your company has bought Power BI Premium, and there is no limitations for all viewers of the shared dashboards. In addition, you can see some discussion in this thread.  

Best Regards,
Angelia

[jimbudde]

Since things move quickly in the PowerBI space, I will provide an update on our experience with this feature.  The following is as of Mid to late May 2018.

• Yes, you can embed Power BI reports in SharePoint Online web pages using the new PowerBI webpart.
• As previously noted, make sure you capture the correct url, by navigating to the report's web page and then go to the File -> Embed in SharePoint Online.  The report can be from a workspace or a published App
• You cannot embed a dashboard at this time in SharePoint online, it must be a report.  I encourage others to up-vote this feature if this a big deal for you.
• The SharePoint Power BI webpart *requires* the modern web page model, the classic page model does not support the PowerBI web part.
• Tip: If embedding a report from a published App, take advantage of a recent feature allowing you to 'Install app automatically' .  If you do not choose this, at least as of right now, users will not be able to see the embedded report in SharePoint.  As noted in the link, use this feature wisely in large deployments.
• Tip: If the reports will ultimately be in SharePoint, design them with this in mind.  When embedded, the reports will be smaller/resized to fit in the SharePoint page as best it can. 

[Anonymous]

Thanks @v-huizhn-msft for your comment. I think with the Premium package, users without Power BI Pro can still view the report embedded on SharePoint, provided that the report was published on the Power BI app workspace with Premium capacity?

[LizBethA]

It is important which Embed Link you also get.  Make sure you get the embed link from the Published App.  If you use the embed link from the report on the Workspace, even if the workspace is on a premium node, your premium users will not be able to view the report in SharePoint Online