Forum Discussion
Advocate IEmbedding a report in SharePoint - making it accessible to entire organization
I am trying to take advantage of SharePoint's ability to embed a Power BI Report into a SharePoint Modern Page. I am encountering issues with permissions and access. My primary goal is to make an embedded report visible to my entire organization, but I am hitting challenges with permissions. It appears that the only thing that makes a report visible to anyone in Sharepoint is membership in the Workspace. I have shared the report widely via powerbi.com, and my testers are able to see the report if I send them a direct powerbi.com link, but the same report embedded in SharePoint is not visible to them.
We have Power BI Premium, so licenses associated with viewing are not an issue.
The audience I need to share with is more than a thousand users, and the only way I can add users to the workspace is one at a time, plus it is then a static list of users that would require manual updating. Is there any way to make an embedded report visible within the organization without manually adding a thousand staff to the workspace? Given that staff are able to view the Report through powerbi.com directly suggests that this is a bug with the SharePoint embedding tool.
Please advise!
I tested just now with an "App-published" report, and a user who is not part of the workspace membership *is* able to see the SharePoint-embedded report as well as the report on app.powerbi.com. Admittedly, this is an app published to a (large) active directory group rather than the "entire organization", and the user does have the App installed (because we push-installed the app to the AD group). Has your end user tester installed the App from which the report is embedded?
11 Replies
BrettHermannAdvocate II
I'm experiencing the same issue as well. I feel like when you use the embed link from a published App in the Power BI Service, it should be tied to all users who are granted permissions to view the App. I'm not sure why it only accepts users that are contained within the workgroup. This does not make any sense to me. Are there any potential work arounds to this? I feel like it's not a feasible solution to create a new workspace and put the entire organization within the group just for embedded reporting.
- GilbertQ
Super User
Hi there
For true embedding you will need to go through the embedding Power BI into an existing App.
You can use Secure Embed which will allow you to put it into an existing web page.
Have we found a resolution to this?
mparowski wrote:I am trying to take advantage of SharePoint's ability to embed a Power BI Report into a SharePoint Modern Page. I am encountering issues with permissions and access. My primary goal is to make an embedded report visible to my entire organization, but I am hitting challenges with permissions. It appears that the only thing that makes a report visible to anyone in Sharepoint is membership in the Workspace. I have shared the report widely via powerbi.com, and my testers are able to see the report if I send them a direct powerbi.com link, but the same report embedded in SharePoint is not visible to them.
We have Power BI Premium, so licenses associated with viewing are not an issue.
The audience I need to share with is more than a thousand users, and the only way I can add users to the workspace is one at a time, plus it is then a static list of users that would require manual updating. Is there any way to make an embedded report visible within the organization without manually adding a thousand staff to the workspace? Given that staff are able to view the Report through powerbi.com directly suggests that this is a bug with the SharePoint embedding tool.
Please advise!
It is going to be very difficult and annoying to add, delete and update all the users in our organization. Premier licensing should be all that is needed to grant access to reports embedded into SharePoint Online.- GilbertQ
Hi mparowski
Could you possibly Share the Report to an existing AD Or Azure Active Directory Security Group?
When completing the Sharing, just remove the options for Allow recipients to share your report and Send email notification to recipientsAnd see if this will work?
Hopefully then you can just have the users sitting in an AD or AAD Security Group to manage all the users.
- mparowski
Yes, I did that, and that's how I know that staff are able to access the report if I send the direct powerbi.com link. The problem seems to be the embedding in SharePoint, which only works when people are members of the workspace. I am not able to add the AD groups to the workspace.
