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?
Hi @taylorp84 ,
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?
I have not found anything better yet. It appears this is the best imperfect solution until Microsoft smoothens this out a bit.
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 Dataset
Workspace 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
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).
Thanks, Gilbert. I am sharing out the report via an App, but if Build permissions aren't granted, the user receives an error that they do not have access to the underlying dataset (which is in another workspace).
I'm assuming the only way to grant them access without giving them the ability to build out reports with the dataset is to go into the workspace with the shared dataset, click on the Datasets tab > <DatasetName> ellipssis > manage permissions and grant Read access?
Absolutely. See below. I did see something in another forum about Microsoft having these permissions granted automatically at one point, but then switching it back to manual. I have not had any formal confirmation on that.
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!