Integration Between SharePoint and Power BI using B2B methodology

[Anonymous]

Hi all,

I am hoping someone ran across this issue and has a solution. Here is our use-case:

We are trying to use the b2b model to give our independent sales reps access to documents, information and sales reports(that are in PowerBI), all of it surfaced through SharePoint. We have the access to SharePoint working properly. As far as PowerBI, it is not working consistently. Here is the process that we go through:

• Invite the users to join the group via Azure
• Then they register
• Assign the group a PowerBI license (one-time)
• Assign group within SharePoint (one-time)
• The user then gets a link to SharePoint
• The go through the sign-on process
• The user can then go to Sales Rep. Portal (BI report)

There is inconsistent results, meaning the first 3-4 accounts work seamlessly but the next 3-4 do not work properly, even with the one’s that don’t work properly we assign an individual license and it still does not work. The one's that don't work, you just see a pulsating logo for PowerBI with no error message. 

Many thanks in advance. 

[v-yuezhe-msft]

@Anonymous,

Do you use "Embed in SharePoint Online" feature in Power BI Service to integrate report to Sharepoint? And the users are not able to view the integrated report in SharePoint,right? If so, the report is located in "My workspace" or "App workspace"? How do you grant users access to the report in Power BI Service?

Regards,
Lydia 

[Anonymous]

Yes, I did use the Embed in SharePoint Online then I go into SharePoint and I add an APP and user the PowerBI app template, then I use the url from the Embed in SharePoint link. The problem is that the users cannot see the integrated report in SharePoint. The report just pulsated with the PowerBI logo. It never returns an error. 

[v-yuezhe-msft]

@Anonymous,

Do you grant the users access to the report in Power BI Service? If the report exists in APP workspace, you would need to add users as members of the APP workspace.

Regards,
Lydia