Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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
Solved! Go to 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.
@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".
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
33 | |
32 | |
19 | |
12 | |
8 |
User | Count |
---|---|
52 | |
37 | |
29 | |
14 | |
12 |