What is the correct way to grant access to external users for a PBI report embedded in SharePoint?

[BBIUser]

Hello,

I need help for the Power BI\Fabric administration.

Power BI report is published in Power BI Service and then embedded in a SharePoint site. The external users already have access to SharePoint and the permissions are granted through SharePoint. The users can access all the contents in SharePoint except the Power BI report.

Now, how to grant access to these external users or what is the correct way to grant access so that they can view the reports in SharePoint? 

Note: These external users have their own Tenant and Power BI Pro License.

1) What permissions do I need to grant in the Tenant Admin Portal?

2) Do I need to grant access to these users in the Workspace where the report is published in Power BI Service? 

Any help is appreciated

Thanks!

[v-saisrao-msft]

Hi @BBIUser 
I wanted to check if you had the opportunity to review the information. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-saisrao-msft]

Hi @BBIUser 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you

[v-saisrao-msft]

Hi @BBIUser 

Thank you for reaching out to the Microsoft Fabric Community Forum. 
 
In addition to the helpful response provided by @rajendraongole1 ,Could you please confirm if your questions have been resolved? If they have, kindly mark the helpful response, give 'kudos' and Accept it as the solution. This will assist other community members in resolving similar issues more efficiently. 

Thank you. 

[rajendraongole1 · Accepted solution]

Hi @BBIUser  - To allow external users to access a Power BI report embedded in a SharePoint site, you need to follow a few steps to configure permissions and settings in Power BI Service and SharePoint.

You need to allow external users to access your Power BI reports. Here's how:

Enable Sharing with External Users:

Go to the Power BI Admin Portal.
Navigate to Tenant Settings.
Look for the Share content with external users setting and ensure it is enabled.
Optionally, restrict this setting to specific security groups if needed.
Allow SharePoint Online Embedding:

Ensure the Publish to web (Public) and Embed content in apps settings are enabled for SharePoint embedding.

Grant access to power bi:

External users need access to the report and dataset in the Power BI Service workspace where the report is published:

Add External Users to the Workspace:
Go to the workspace where the report is published.
Click on the Access button.
Add the external user's email (e.g., user@externaltenant.com) to the workspace.
Assign them at least the Viewer role. If they need to interact with datasets, you may need to give them higher permissions.

Embed a report web part in SharePoint Online - Power BI | Microsoft Learn