Forum Discussion
Power BI Premium Embed SharePoint Online
I've been searching for documentation or an example of this but haven't had any luck. At the Data Insights Summit this year, an example was shown of Power BI Premium Embed in SharePoint Online. ...
Okay 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.
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.
I'm having the same issue, but with internal users who don't have Pro licenses. I'm hesitant to add them to my O365 group as that would mean they could potentially have more access than they should.
Would be good if Power BI could make viewing SharePoint embeded reports available for non-Pro users, according to the permissions set-up on the Dataset / Dashboard that's shared with the user.