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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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".



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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