cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power BI Team
Power BI Team

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 account in SharePoint Online pages so you can build secure internal portals easily. The web part requires users configuring the web part and consuming the reports to have Power BI Pro licenses.  

 

Let's use this thread to discuss the new Power BI report web part for SharePoint Online.   

 

Please read the documentation before asking a question, posting a comment below. The documentation contains answers to common questions and workaround for any known issues.

 

Known Issues:

When adding the Power BI (preview) web part, you are asked to sign-in but are not able to.

You will see error message similar to:

  • "We need you to sign in again. Once you do, we'll bring you back here."
  • "An error occurred, please try logging out and back in and then revisiting this page"

To resolve this issue, ensure your tenant is set to "First release for everyone". To enable SSO, the Power BI web part relies on new Authentication APIs provided by the SharePoint team and only available when First release for everyone is selected. See the Office 365 documentation for detailed steps

 

87 REPLIES 87
Advocate II
Advocate II

This is great news.

 

Is it possible to pass filter values to the app?

 

Best regards

Jeppe

The web part does not receive filters from other web parts at this point.  Would be a good thing to add to https://ideas.powerbi.com

Frequent Visitor

Have to agree with most of the replies on this. The PowerBi Pro requirement is going to make this non-usable. I can understand requiring it to publish onto SharePoint, but for the generic user having to do it doesn't make sense. A user on a SharePoint page simply won't go through the rigamorale to register, they won't bother and the information won't be viewed. Please review this decision.

I could certainly see that for some sort of public instance or something like that.  I'm assumeing that we'rd talking in an enterprise context(with SSO and auto-enrolled users) where the competition for an enterprise solution seems to be much more expensive.

People seem to be having difficulty if they haven't ever signed into powerbi.com with their Office 365/org account.  After that, everything is gold (small E5 tenant here).  Is there any way to get around people having to go in and simply sign-in to PowerBI once?  Something that can be set from the admin side or is this a necessary evil?  Right now, if people haven't signed in, they don't even see the web part.... no error, etc.  

 

When it works..... it works well and is easy to setup.

Thanks for reporting this. We'll definitely look into it. You might try assigning those users Power BI licenses ahead of time (or have you done this already) before they view the web page for the first time. 

@lukaszp -- everyone in our tenant is E5 so aren't those users technically PowerBI Pro users already, therefore, no need to assign licenses?

Resolver III
Resolver III

Thanks for this, it all works as advertised for me, but I'm a little mystified as to the use case.

If everyone who accesses these shared reports requires a Power BI Pro licence, then what is the benefit of putting the report on Sharepoint ? The Power BI pro users can access through Groups, Content Packs or shared Dashboards. What extra does Sharepoint provide ?

 

Oh, one more thing, PowerBi service now has a "Preview Features" option, (in Settings). So why is this preview feature being shown on the main menu, why can't we turn it on (and more importantly OFF) with the "Preview Features" ?

 

Stuart

@lukaszp Do you have an answer to the issue with PowerBI licensing? I have viewed every single thread on this topic and you have clearly ignored questions about licensing while at the same time answering other questions. Is it that you do not have an answer, that you are waiting on one, or that you haven't even bothered to pursue this issue with the people above you? I see no reason why this should be such a sensitive topic. IF Microsoft wants companies to purchase and use Sharepoint online, you need to make the tools affordable and comparable to previous iterations of Sharepoint, or else nobody will ever move to the cloud. It is like selling someone a desktop computer and then charging $10,000 for a mouse and a keyboard. It makes absolutely no sense. And the issue is only exacerbated by your refusal to address it.

@Burningsuit the use case is pretty straightforward - many organizations use SharePoint Online to manage team, build portals, etc. In many cases these teams or portals need to display data to help people be productive. People in those organizations know to go to those portals/pages to get the latest information. So now, Power BI reports can be embedded directly in those pages.  It'll make rolling out standard reports to 'everyone' who needs them easier. .

 

You mentioned Office 365 groups. Each group has it's own team site. Now you can not only put reports into group workspaces in Power BI, but you can also reflect those back into the group's team site pages as well.

@lukaszp so then if the use case is that SharePoint users can consume PowerBi reports without going into PowerBi. Why then charge them a PowerBi Pro licence fee for features that they may never use ?

 

Stuart

@lukaszp, the idea is great, i guess no one against it. The only question why all these people who potentially could see the reports (okay, their emloyer) shall pay 10 bucks/month per person or so for the possibility to see such reports.

MVP

We can not enable First release for everyone in large organisation without testing . Is there option to enable for selected User first for testing?

The web part requires some authentication APIs that SharePoint has enabled only as a Tenant level first release. So this mean users would not be able to log-in to the web part (you saw the login related issues earlier on this thread was due to this very issue).

Documentation also explain enabling "First release for selected users".

 

If i have selected user in first release with Power BI pro license, will it work for selected first release users?

 

Is there any option to enable only this feature to all in organization in admin center?

 

 

Based on my exerience it doesn't work for only selected users on First Release, see known issues in announcment

Correct, you need to use the "First release for everyone" option.

That is so so.... frustrating Smiley Sad

 

First Release for Everyone? As shared by someone else earlier on this post, we can't go to that type of settings in a large organization.

@MichaelP unfortunately to ensure you don't need to sign-in to Power BI to view the report (SSO), we need some new APIs from the SharePoint team. So those APIs are what forces the web part to be First Release for Everyone. Once those APIs are in all of SharePoint Online, we can look into whether we can switch the preview for the web part to First Release for specific users.

We need for it to work only for selected first release users, we cant have the entire org on first release.

So we won't be in the testing. Unfortunate.

 

Also, as shared by others already, the need for Power BI Pro to view Power BI reports or Dashboards in SharePoint is not acceptable.

Hopefully this constraint will be re considered and removed very soon.

 

Such approach is "a killing in the egg" practice. At some points our effort to market your product, might stop short soon.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors