Forum Discussion
Shared Datasets and underlying permissions
Hey gang - I have a question around using shared datasets and the proper way to grant permission to the underlying dataset. If a report in a separate workspace is using a shared dataset, what is the proper way to grant permission to that underlying dataset? Currently, if the user doesn't have access to the underlying dataset, they receive a permissions error and are not able to view the data in the report. I don't want the user to be able to access or read this dataset in anyway apart from simply being able to view the data in the report. The only way I saw to get this working is to go into the underlying dataset in the separate workspace and grant the user Read access. Is that really the best practice right now?
15 Replies
Hi Anonymous ,
I have exactly the same issue. Do you already have a better solution then giving read access to the underlaying dataset in the other workspace to individual users?
Just curious not sure if anyone has tried this yet but if "Build Access" was granted via the App to a user - This would mean the user can build out their own reports via this "shared dataset".
So lets say user A has the dataset and shared it out with build access to user B. Lets say user B then shares it out to user C
Does user A need to grant "read permissions" to user C in order to see the underlying dataset?
Or does user B grant access to user C - Therefore user A has no clue beyond user B where the dataset is being spread out to?
Huh, me too.
Trying to share with external users.
Workspace 1 has the DatasetWorkspace 2 has a trimmed down copy of the report
Workspace 2 has an app, a group (of which these external users are a part), was given app access
Yet it keeps compalining about them not having access to the underlying dataset
- Hi there
The permissions that a user needs to build reports off a shared dataset is the build permission. You can enable this permission from either when you share the App with the user.
Or when you go into the dataset settings and then click on permissions and give them the access to build.
Here are more details in my blog post: https://www.fourmoo.com/2019/10/08/power-bi-bulk-changing-permissions-read-reshare-build-on-datasets/Thanks, Gilbert. My main question though is how to share out the proper permissions when I don't want users to have Build access. I want them to simply be able to see the report. I don't want them to be able to be able to view or access the underlying dataset at all (besides obviously being able to see the data from it surfaced in the report).
- Hi there
In order to do that you can share the reports via an App from an App Workspace.
That will allow them to have the permissions to view the data in the associated reports that have been shared in the App.
