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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Vegard1985
Helper I
Helper I

Share app and workspace with external user, no data?

Hi,

 

We're currently in need of sharing some content with an external party.

Need to fix two scenarios:

1. External guest user gets access to an app

2. External guest user gets access to a workspace with edit rights

 

We have followed the MS documentation on Azure B2B for planned invites ( Azure B2B Planned Invites ). I've created a security group and added a test-person to this group. As for licensing, the guest users will bring their own Pro license. As a Power BI tenant admin, I've also enabled the option "Allow external guest users to edit and manage content in the organization " for this security group.

 

I've published a dummy app from a dummy workspace to test things. When I added the security group to the app access list, the test user was able to login, we saw that the Pro license was functioning from that persons own organization, but when opening the app, visuals was missing data. "Couldn't load the data for this visual".

 

The two dummy reports in this workspace is however mostly based on a dataset from another workspace. But I also went to this other workspace, and added a view permission for the security group on the dataset that was used. Still no data is visible.

Could anyone please help out in how we should set up this properly?

 

So in short:

We want to share apps and workspaces with datasets from other workspaces, with external guests who bring their own Pro license. On which objects do we need to maintain an access for these users?

 

Currently I'm trying this:

Security Group has "Viewer" access to workspace A

Security Group has "Read" access to dataset in workspace B

1 ACCEPTED SOLUTION

I did create a ticket to get this solved, and the solution was simple.

For external users to be able to get data from a composite model, they need to be set with a permission level of at least "Member".

As this happened on a call, I'm not a 100% sure if this actually was the case, but I believe it was said that for composite models to work from different workspaces, a user needs to have the same type of access on both workspaces as well. "Member" and "Member" is fine, "Member" and "Admin" could mess up. Again, not totally sure if I understood that point correctly, but it was repeated to set the level to the same.

 

So end of my story was:

I created a central workspace for any current and future datasets we might use in composite models, added the external users as "Member" of this workspace.

I then put the permission level to "Member" in the "app"/"report" workspace, and they could see data.

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@Vegard1985 Are you using RLS?

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

I did create a ticket to get this solved, and the solution was simple.

For external users to be able to get data from a composite model, they need to be set with a permission level of at least "Member".

As this happened on a call, I'm not a 100% sure if this actually was the case, but I believe it was said that for composite models to work from different workspaces, a user needs to have the same type of access on both workspaces as well. "Member" and "Member" is fine, "Member" and "Admin" could mess up. Again, not totally sure if I understood that point correctly, but it was repeated to set the level to the same.

 

So end of my story was:

I created a central workspace for any current and future datasets we might use in composite models, added the external users as "Member" of this workspace.

I then put the permission level to "Member" in the "app"/"report" workspace, and they could see data.

No, RLS is not in use (yet).

Thanks, I'll try to open a ticket if noone has some ideas to try out.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors