Forum Discussion
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
The security issue of publishing a web link is a huge problem, this new Web Part appears to start to address the issue. By asking us to purchase the Pro client just moves the problem further down the chain. The new issues are budget and publishing control. I would ask Microsoft to consider allowing non-Pro clients view capability otherwise we will continue to need to look for a differnt solution.
I just don't understand where and why the thought of needing to have a pro license came into the picture for Microsoft. Like has been said before, if someone actually has access to the report, what are we paying for? The ability to consume the report through a different medium? Is the issue here consumption and using the web part to surface reports potentially public (for the whole company public, not for public meaning for the world), thus increasing resources to host/process/display the data?
That's the only rationale I can come up with as to why they would require a pro license for VIEWING purposes. Microsoft, help us understand here, that's all we are asking for. Clearly this doesn't make sense to your clientbase as most people are scratching their heads at this point.
- jimbobTX
Advocate I
Yeah - this.
It's one of the most frustrating restrictions placed on Power BI, heroin dealer-style: your first hit is free. Kinda bush-league, if you ask me.
Our organization is a governmental research agency and we use Sharepoint Online to collaborate with dozens of other state and federal agencies, municipalities and other academic institutions. Some of the datasets are large and SPO requires using Power BI for Excel workbooks that exceed 10MB.* We had really hoped the new Web Part would help with our integration issues, but it is a step backwards as it requires a monthly license to even view the content on Sharepoint.
It was a big enough hurdle to collaboration that the our in-house researchers had to sign up for a free license just to continue with their SPO collaboration. To take it a step further and require a Power BI license for viewing the data from a Web Part in SPO is a non-starter. We have no control over whether the viewers can purchase a pro license as we use Sharepoint Online to collaborate with dozens of other state and federal agencies, municipalities and other academic institutions. And these datasets cannot be share to the world so the anonymous web share option is out.
Somebody let me know if I am missing something. At this point, it seems the PowerBI team is undercutting the collaborative features that Sharepoint has at its core and is marketed upon.
webguy It's a good ask to make it easier to share content across organizations. We're tracking this with the following idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17485666-azure-b2b-collaboration-add-external-user-to-gro
If your organization has on Office 365 E5 license, internally your users already have the required Power BI Pro license to use the web part.
We have an on-prem SharePoint 2013 solution. Is there any way to incorporate these types of web parts with an on premise install?
- Burningsuit
Resident Rockstar
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
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.
- Burningsuit
Anonymous 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 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.
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.
FugiHelper I
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.
- o365spo
Advocate III
Microsoft is telling us EVERY USER on the tenant (not just those that need acces to the webpart ) must be on First Release because some new SSO feature has changed. Is this true? Please explain why? This is our production tenant and we have over 20,000 users, so that's not an option.
When can we expect general release or for that requirement to change?
Adding to the conversation, the webparts needs an option for filters and parameters. We would really like to see a URL query string parameter option.
Also, now that we are talking about SharePoint, I understand Azure SQL databases can have a live PBI connection, Why no live connection to SPO Lists?
o365spo The web part is in preview and relies on APIs that are in First Release for the tenant. So we're just saying that if you'd like to start using the web part, you can. I don't have any GA date guidance to share with you right now. The preview has recently started and we want to ensure a great experience before we declare a GA. We also need all of our dependencies to exit First Release.
Your ideas about parameters/filter input and direct query for SharePoint Lists are good ones - could you ensure you share that on https://ideas.powerbi.com.
clechner77 If you have E5, then your users have Power BI Pro licenses, no need to get anything else.
Anonymous -- right, we're set as far as licensing. I was just passing along that we are an E5 tenant so you knew that our users not seeing anything in the web part unless they log in once to powerbi.com wasn't a licensing issue.
- MichaelP
Hello,
We are pleased to start playing with SharePoint Online Web part as it is now available for all users.
I believe I found a limitation just now on it. It seems filtering in the URL is not implemented at this point? Correct?
If confirmed that this limitation is there (not me doing it wrong) would you mind sharing with us it that is in the plan to implement it for GA?
That is necessary in many business case where we need to produce reports filtered in context.
Best regards.
I got very excited to try this out. Been waiting a long time for this. I am a first release customer and added a Modern Page to my SharePoint Site. I added the Power BI (Preview) app to the page and immediately get the following error in the frame:
"An error occurred, please try logging out and back in and then revisiting this page. Correlation id: undefined, http response status: 400, server error code 10001, message: Missing refresh token."
I followed all the steps in the documentation. Any ideas?
Yes I sure did. Even cleared temporary internet files etc.. Same result in Chrome as in IE 11.
Now for clarification I am using an Office 365 Group with a Modern Page in that. Is that the issue? We have Modern Team Sites off at the Tenant Level.
I've added the web part and get a login prompt:
Power BIWe need you to sign in again. Once you do, we'll bring you back here.Clicking on the Continue button redirects back, but never gets me past this prompt. I'm logged in to PowerBI Pro, have a Pro license, first release, etc.For those failing to login, please 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:
Thanks for the reply. I've set first release for everyone, waited a bit, logged-out/closed all browser windows, but still get the SSO authentication issue. Thinking it was a page issue, I created a new a page but now the PowerBI web part is missing from the choices! We have ~30 E3 users, maybe five of those have PowerBI Pro. Do all users have to have Pro in order for any of us to add the web part?
edit: just took an hour or so to update, but I can authenticate now.
Is the requirement that consumers of the web part have a Power BI Pro license only during the preview or is this going to be a requirement at GA as well? This is a simple question, I need a simple answer.
In SharePoint Online, Power BI web part consumers and authors need a Power BI Pro license. Hope that's simple enough.
How convienent, you won't allow us to embed private data which is shareable via dashboards for free. Then to embedd within our own SharePoint online space your require Pro for those users.
I can't purchase 500 licenses of Pro, make the authors have it something, but not consumers. We can't implement with these restrictions.
- VP
Most Valuable Professional
We can not enable First release for everyone in large organisation without testing . Is there option to enable for selected User first for testing?
- VP
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?
