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

Sharing a dataset but NOT allowing anyone to edit it?

I would like to create a dataset and share it, however, I need to ensure the report creators can NOT edit the dataset or adjust SQL behind it.

https://docs.microsoft.com/en-us/power-bi/desktop-report-lifecycle-datasets

 

I looked at the dataset option linked, however, it appears people can still edit them?

 

The idea here is to setup hard coded WHERE conditions in the TSQL so that the departments/users of the datasets are limited to their specific areas.

 

If I deploy a dataset, can I ensure that report authors cannot change it?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Sharing a dataset but NOT allowing anyone to edit it?

@OneWithQuestion ,

 

I'm afraid currently there're no such kind of roles in workspace. As a workaround, you can publish your app and share it with other users, then the users be shared with can only view it.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Sharing a dataset but NOT allowing anyone to edit it?

@OneWithQuestion ,

 

You can create a new app workspace and assign users with roles like members or contributors.

Capability Admin Member Contributor
Update and delete the workspace. X    
Add/remove people, including other admins. X    
Add members or others with lower permissions. X X  
Publish and update an app. X X  
Share an item or share an app. X X  
Allow others to reshare items. X X  
Create, edit, and delete content in the workspace. X X X
Publish reports to the workspace, delete content. X X X

 

Reference:

https://docs.microsoft.com/en-us/power-bi/service-new-workspaces#roles-in-the-new-workspaces

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Sharing a dataset but NOT allowing anyone to edit it?

To clarify then, even at the lowest permission level (contributor) they would still be able to modify (edit) the data source and change the underlying queries, etc...?

Community Support Team
Community Support Team

Re: Sharing a dataset but NOT allowing anyone to edit it?

@OneWithQuestion ,

 

I'm afraid currently there're no such kind of roles in workspace. As a workaround, you can publish your app and share it with other users, then the users be shared with can only view it.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 426 members 4,115 guests
Please welcome our newest community members: