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.
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
I should have clarrified that we are not using sharepoint.com cloud accounts, but rather enterprise logins with a shib based single sign on. So the only way to activiate that tenant level APIs in First release is by having all users on the tenant (even those that don't need the new web part) on First Release? Please explain how that works.. is it automatic?
@mahimabedi (and others) there's no current plan to deliver this to First Release for select users. There are big technical dependencies today that prevent us taking that step, as much as we'd really like to. I appreciate all the feedback on it and interest to use the feature. For those who cannot configure First Release for Everyone, rest assured we're working as quickly as possible to get everything in place to light this up for any SharePoint user.
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.