Forum Discussion
Set up Shared dataset permission errors
I've found a solution and that is to implement RLS. 😉
Super UserHey Anonymous,
I have a clarification question - in the APP in workspace 2, do you have permissions for the user in question there?
Hi collinq ,
Yes. The user has the viewer role in the APP workspace & in workspace 2. If the user goes to ''Apps'' he sees the dashboard, but when he open the app/report he got the error "Something went wrong Unable to load the model"
If I assign him the contributer role in workspace 1 (dataset), the error disappears and he is able to see the data in the app/report, but we don't want to give end-users contributer role. So the issue is that the user CAN see the APP or report in the workspace but is not able to see the data.
- collinq
Hey Anonymous ,
I don't see you mentioning it - but are you using RLS? (Grasping at a straw there.) Is this Direct Query or Import (or something else)?
Hi collinq
No we don't use RLS. And this is Import data.
- collinq
hey Anonymous ,
Well, I was hoping that this was related to RLS or the data itself. I think the issue is the cross-sharing. I found this article that has Considerations and Limitations that seems to indicate they need build access to the dataset. (Exactly what you do NOT want to do.)
I say that based on this sentence:
- As an app publisher you have to make sure that your audience has access to datasets outside of the workspace. Otherwise, users will encounter issues when interacting with your app: reports won’t open without dataset access, and dashboard tiles will show as locked. Also, users won’t be able to open the app if the first item in its navigation is a report without access to the dataset.
Which I found on this page: Intro to datasets across workspaces - Power BI | Microsoft Docs
This one might be helpful as well:
Control the use of datasets across workspaces - Power BI | Microsoft Docs