Sharepoint PBIapp - multiple pro users

[kenthub]

Here is my structure:

Me - Setup sharepoint, create all the powerbi.pbix files and such. Pro user

Clients - access to sharepoint

Client stores - sharepoint access. One store will have a pro account that hosts all reports/dashboards.

When I try to use the sharepoint PBI webapp on a modern page it only works/viewable if i'm logged in with the Client Store creditials and create the page.

I want it to be viewable by Me, Clients, and Client Stores when I create the Sharepoint modern page by ME. Does this make sense?

Here is a picture of trying to use the sharepoint link code created under the Client Store account while logged in under ME account. I am unable to get the page name information.

Here is a picture of the managed permissions in powerbi site.

Does anyone know a fix for this so that I do not have to use the embed code?

[v-yuezhe-msft · Accepted solution]

@kenthub,

The embed link is created by client store account in Power BI Service, the SharePoint page is created by you when you log in SharePoint Online using your own account, right?

If that is the case, publish the PBIX file to a app workspace in Power BI Service logging in with client store account, then add you as a member of the app workspace, also make sure that you have edit permission on the app workspace. This way, you should be able to embed report to SharePoint page.

In addition, for other clients  to view the report in SharePoint Online page, make sure that you have shared the report to clients in Power BI Service through adding clients as members of app workspace.

Regards,
Lydia

[kenthub]

@v-yuezhe-msft

So the solution works but only people who are added as members and admins can view the page. When I try to add our clients, who have an outside email address (not gmail or the likes, but their own business email), they cannot view the Power BI report on the sharepoint page. They also can't be added as admins or members when creating the workspace app.

The embedded sharepoint link I used came from the App Workspace. Should I be using the link from the actual App itself or should it work with the App Workspace link?

[v-yuezhe-msft]

@kenthub，

You would need to add users as members of the App Workspaces in order for  the users to view the report in SharePoint.

If you want to share the report to users outside your organization, consider to  use Publish to web feature to generate embed link and then embed the report to your SharePoint site. However, there is no security in this case.

Regards,
Lydia

[lgonza24]

I have created a SharePoint page with an embeded PBI report in order to share with my colleagues and company's managers just the visualization of the reports.

In order to do that, PBI sets that all of the viewers have to have PRO version, which (from my point of view) it's crazy. is there another way (without PRO version for the viewers) to share the visualization of my reports in a secure way (without pubblishing to web)?

Thanks.

Luis

[Anonymous]

Probably you can check this 

https://community.powerbi.com/t5/Service/Power-BI-embedd-on-SharePoint/m-p/2544231

[kenthub]

Thanks I will give that a try this weekend and update this reply with results.