Forum Discussion
Advocate IPower BI Premium Embed SharePoint Online
Microsoft EmployeeHi mgraff,
It's said embed with Sharepoint Online is a Pro feature in the documentation of the second link of your post. I'm afraid this doesn't suit your scenario.
>>>
Note:
Embed in SharePoint Online is only available with Power BI Pro. Each user that views the report must have a Power BI Pro license. If they do not have a Pro license, they will be prompted to sign-up to view the report.
Best Regards!
Dale
Advocate II understand and agree the documentation is lacking. However, please see this from the Data Insights keynote:
https://youtu.be/zaVGt-IbuhU?list=PL1N57mwBHtN0qxCHKMzN-q2K3r6dBbXU8&t=2247
SharePoint + Power BI Premium Embedded example. I need exactly what the video describes.
- v-jiascu-msft
Hi mgraff,
I have searched a lot of documentations and I didn't find out a precise answer. I would suggest you create a support ticket here for more help: https://powerbi.microsoft.com/en-us/support/pro/.
Best Regards!
Dale
- mgraff
Thanks, I've submitted a ticket. I'll send a response and let everyone know what the resolution was.
- MarkcgraffOkay found the solution. It does work but with a little bit more involved than expected. Public web embedding is inappropriate because I want users to be authenticated to view these reports. I needed external accounts including public addresses (i.e gmail addresses) to have access to the Power BI reports like with SharePoint Online itself (which is where I'm embedding in this case).
The trick was to set up the external accounts in Azure AD and give them access to the Power BI Free license. I know the documentation for SharePoint Online Power BI Embed states users must have the Power Bi pro license, but this is not required when using Premium Embedded. They do still need the Power BI free license assigned to them though.
The users also had to be members of the workspace with Premium capacity assigned to it, even though the users couldn't access the workspace through the Power BI service. So that part wasn't very intuitive sans documentation. I'd get errors trying to add the users directly to the workspace, so I added them to the office 365 group for the workspace. Here is the full list of steps.
1. Create Premium Capacity and assign it to a workspace in Power BI.
2. Upload report to workspace.
3. Get “Embed in SharePoint Online (Preview)” link from Power BI report.
4. Embed in SharePoint Online Modern Team Site using new Power BI (Preview) web part.
5. Create external accounts in Azure AD (tested with a 3rd party company account and with a public Gmail account).
6. Grant external users Power BI (free) license in Azure AD or Office 365 Admin.
7. Grant external account access to SharePoint Site (read only is fine).
8. Add external user to the premium assigned workspace in Power BI (mine failed with error that the user couldn’t be validated)
9. If 8 fails, add them to the corresponding Office 365 Group for the same workspace.
Now both accounts can view the embedded Power BI in the SharePoint Online site without a Power BI Pro license. Inadvertently this is also a workaround for needing to be able to share Power BI content with authenticated public accounts (gmail, yahoo, etc), although a minimum of the Premium Embed (EM1) capacity is required.