Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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:
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
Does this article what Reza posted?
http://radacad.com/embed-power-bi-in-sharepoint-online-office-365-integrated-sharing
Hi all,
I understand that in order to embed PowerBi report in SharePoint online, we need to have PowerBI pro license
And the report viewers will need to have PowerBI pro license as well.
We are currently using E1 license.
So in order to embed PowerBI report, can you advise which option below is feasible?
1. E1 + PowerBI Pro
2. E3 + PowerBI Pro
3. E5 (PowerBI Pro included)
I understand that E1 SharePoint Online doesn't have PowerBi Web part feature, so option 1 is not feasible right?
The "REQUIRED" PRO license for every viewer of the embed web part is a real deal-breaker.
From the point of view of our typical customer, e.g. an organization (company, association, small-businesses) which has not the capacity or the needs to upgrade to the Office E5 tier, it is only impossible to adhere to that kind of restrictions.
I understand the need of a PRO license for the content creators but not for the viewers.
I just want to point out that by sticking to this licensing restrictions, YOU (Microsoft) are losing both in customers and in image.
Many people have said approximately the same here before but I cannot stress this enough, as of now, we cannot sell Power BI to our customers.
Power BI Team, please consider this issue seriously.
I finally figured out how to show a Power BI report on a SharePoint modern page, I basically tried the following options
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
As Power BI Embedded announced, can anyone tell if we can leverage Power BI embeded to allow users to view a Power BI report on SharePoint online page without a Power BI Pro license?
Thanks
I found out the latest conversation was middle of 2017. As 1 year later, can anyone from MS point me out that if viewing a SharePoint webpart embeded Power BI report still requires people with Power BI Pro license? if that's the case, what would be recommended if an organization needs to share a basic report to a broad audiences who only have E3 and Power BI Free license, or no license. I understand Power BI Premimum license allows user to show a report to non license audiences. As it's expensive, it's kindly discourage people to use Power BI when compare to other BI tools.
Thanks
I work for a charity and have just been revisiting Power BI as it has many features that I find very useful.
Sad to see that after more than 12 months, it seems that Power BI reports can still only be shared with other Power BI Pro users unless we use the Premium route which is also prohibitively expensive.
I shall be going back to PowerPivot which does a very good job and can be shared with the rest of the organisation.
It is a shame that such a powerful reporting tool as Power BI can effectively only be viewed by a very small number of people in an organisation.
Robd
Hello,
We are planning to allow Free users access to reports that are embeded in sharepoint via below two setting:
1. Assign the app workspace where report located to Premium capacity.
2. Add the Free user to the list of members of that app workspace
The instruction on Power BI (https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo) is to embed report through webpart to the Modern Page. Which the instructions looks not applicable and the web part is not available while we are still using the Classic SharePoint UI.
Is there anyway we could embed report to the sharepoint while still using the Classic SharePoint UI? Or did I miss on reading something?
Thanks 🙂
Regards,
Vanessa
Using power bi in a classic sharepoint page:
I'm not 100% sure it works outside my direct team, but what I did is create a modern page and embedded the power bi into that, Then on the classic page, I used the script editor webpart and did an iframe to the modern webpage. I'm still working on the formatting, but it seems to work well for my team and I. I'm having the issue where I can't share it out with anyone else though... everyone outside my direct team is just getting a content unavailable.
I just discovered the cause of a problem that has been frustrating me for a week regarding this web part. I am using AD Universal Security groups to share access to the report.
My issue was that some members *of the same group* would see reports rendered in Sharepoint 365 while others were issued "Content not available" messages.
It turns out that users needed to open the report at least once on the Power BI site. After that, the embedded links would work properly. Obviously not what we want for this feature, but maybe this will save someone some pain during troubleshooting.
I think the user just needs to access PowerBI once period, then it should work going forward. Or, I think you can manually license them too with Powershell. Ultimately, that first access adds a license for the user, then all should work.
I just discovered the cause of a problem that has been frustrating me for a week regarding this web part. I am using AD Universal Security groups to share access to the report.
My issue was that some members *of the same group* would see reports rendered in Sharepoint 365 while others were issued "Content not available" messages.
It turns out that users needed to open the report at least once on the Power BI site. After that, the embedded links would work properly. Obviously not what we want for this feature, but maybe this will save someone some pain during troubleshooting.
Dear all
Have followed this conversation and have to further emphasize the other comments: Idea great, but sadly not well implemented.
A reporting area within SharePoint makes sense, especially for O365 groups, but bear in mind that O365 Groups are disabled in most organizations as this can get out of hand with all the group websites, mail adresses etc. created every time.
Pro Licenses seem to be a requirement for viewing a report on SharePoint, but what about the premium license? So far, premium has not popped up in this thread. Can I use my premium capacity to show PowerBI Reports in SharePoint?
Thanks for the help, really hoping that we do not have to reconsider our BI Strategy.
Hi airfreigher,
A couple days ago John White wrote an article where you can find an answer about your question:
I hope that will be helpful for you 😉
Has Microsoft decided to loosen the requirements on the PowerBI licensing yet? It is completely unrealistic to expect an organization (of 7,000+ employees) to purchase a PowerBI pro license for every single person that needs to view a report. The public embed WILL NOT work because I am dealing with sensitive (HIPAA Protected) data. What is the recommendation here?
Hi,
Could someone confirm if the users really need to be on O365 first release in order for this to work?
When looking at the documentation it looks as if that requirment has been removed? https://powerbi.microsoft.com/en-us/documentation/powerbi-service-embed-report-spo/#requirements
Is it that the authenticating API's is moved to GA in O365 now so SSO should work without first release?
Br,
Magnus
I just checked. We have users who are able to use the web part who are not in first release.
Any chance we will be able to customize the width and height of the web part in the near future? We have a few reports that exceed the default web part size and can't find any way to adjust the dimensions to fit the entire report without vertical and horizontal scroll bars. I hoped to add some javascript to adjust the iframe size as a workaround but then discovered the modern pages don't allow embedded javascript like the classic pages did.
Any chance we will be able to customize the width and height of the web part in the near future? We have a few reports that exceed the default web part size and can't find any way to adjust the dimensions to fit the entire report without vertical and horizontal scroll bars. I hoped to add some javascript to adjust the iframe width and height as a workaround but then discovered the modern pages don't allow embedded javascript like the classic pages did so there's no way I can find to accomplish this currently.
Has anyone gotten this to work for more than one person?
I had no problem inserting a report in the web part and it works fine for me. However, when I shared it with someone he just gets the message "This content isn't available". He has a Power BI Pro trial and can see the report fine in Power BI. He is on first release in Office 365 and has Member permissions to the SharePoint site.
If someone else has this working can you tell me if you had to set up some other permissions?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
39 | |
26 | |
21 | |
19 | |
10 |
User | Count |
---|---|
40 | |
36 | |
34 | |
20 | |
14 |