Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
manoj_0911
Helper V
Helper V

How to Efficiently Share Power BI Reports with External Users from Another Organization?

We are from ABC Solutions and have created a set of Power BI reports that need to be shared with XYZ users from another organization. Initially, we thought of adding an XYZ admin account to our ABC Solutions 365 AD account and sharing reports with the XYZ admin, who would then distribute them to XYZ users. However, it seems that for the XYZ admin to share reports, each XYZ user's email must be added to our ABC Solutions 365 AD, which is not feasible.

 

Specifics of the Issue:
1. We shared the workspace (FINAL PROJECT) with an XYZ admin user added as a guest in our AD, which didn't work.
2. However, when I (as an admin within ABC Solutions) tried sharing the same workspace with another internal user, it worked fine.
3. The FINAL PROJECT workspace is not visible when accessing Power BI using the base URL (`https://app.powerbi.com`), but it shows when using a direct tenant URL.

Our Requirements:
We need a scalable way to share reports with multiple xyz users without requiring all xyz users to be individually added to our Azure AD.

 

Questions:
1. Is there an efficient way to share Power BI content with external users from another organization using B2B sharing or other methods?
2. How should we configure sharing permissions to avoid errors and ensure the external xyz admin can share the workspace with xyz users?
3. Are there any specific settings in Azure AD or Power BI that we need to enable to allow seamless cross-tenant sharing?

We are on a tight deadline and would greatly appreciate any guidance on the correct approach to achieve this.

1 ACCEPTED SOLUTION
SaiTejaTalasila
Super User
Super User

Hi @manoj_0911 ,

 

Please refer this article -

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-azure-ad-b2b

 

If adding users is your problem then you get all their emails ID's through a Excel files or through a survey and you can create a power shell script to add each user to your security group by passing their email id to that call then users will be added one by one to your group.

 

https://learn.microsoft.com/en-us/rest/api/power-bi/groups/add-group-user

I hope it will be helpful.

 

Thanks,

Sai Teja 

View solution in original post

1 REPLY 1
SaiTejaTalasila
Super User
Super User

Hi @manoj_0911 ,

 

Please refer this article -

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-azure-ad-b2b

 

If adding users is your problem then you get all their emails ID's through a Excel files or through a survey and you can create a power shell script to add each user to your security group by passing their email id to that call then users will be added one by one to your group.

 

https://learn.microsoft.com/en-us/rest/api/power-bi/groups/add-group-user

I hope it will be helpful.

 

Thanks,

Sai Teja 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors