cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SBeat Regular Visitor
Regular Visitor

Shared Dataset and Permissions

Hello, 

 

I am looking for a little clarification on the Microsoft documentation of the Power BI service linked here. Specifically I am curious about this description of datasets...

Power BI introduced Build permission in June 2019 as a complement to the existing permissions, Read and Reshare. All users who already had Read permission for datasets via app permissions, sharing, or workspace access at that time also got Build permission for those same datasets. They got Build permission automatically because Read permission already granted them the right to build new content on top of the dataset, by using Analyze in Excel or Export.

 

Does this mean a user who has viewer access to workspace, but the report is set to NOT export the data to the user, can analyze the data in Excel and potentially alter/overwrite the dataset?

 

I am trying limit/lock changes to the dataset with exception of creating new reports of the existing dataset.

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Shared Dataset and Permissions

Hi there

In all cases a user cannot overwrite or insert any data into a dataset.

What the above meant is that a user could build another Power BI Report and dashboard off the dataset.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Shared Dataset and Permissions

Hi there

In all cases a user cannot overwrite or insert any data into a dataset.

What the above meant is that a user could build another Power BI Report and dashboard off the dataset.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

SBeat Regular Visitor
Regular Visitor

Re: Shared Dataset and Permissions

Thank you for helping me understand. My next inquiry follows off what you said. "In all cases a user cannot overwrite or insert any data into a dataset."

 

Is there a way to restrict the ability to alter/change/overwrite a dataset from the Power BI Desktop one has workspace access to? I know now that viewer access to the workspace will prevent that but how about the contributor or member roles?

 

 

Super User
Super User

Re: Shared Dataset and Permissions

Hi there

Unfortunately even the Member and Contributor roles allow users to publish datasets to the app workspace.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)