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

Setting up user who can create reports/dashboards but not edit datasets...

Is there a way to setup a user who can create reports (from datasets) and create and share dashboards, but not make any changes to datasets or to any existing reports/dashboards that they didn't create?

 

Currently, the only way I know to allow users to create reports is to add them to the admin group, which gives them full access to everything, including existing datasets/reports/etc. It also bypasses any RLS. I'm looking for a way to create a user who is limited by RLS but can also create reports off of existing datasets without being able to modify anything existing objects.

1 ACCEPTED SOLUTION

Accepted Solutions
NishanthV Regular Visitor
Regular Visitor

Re: Setting up user who can create reports/dashboards but not edit datasets...

One Way to achieve this is 

 

Create a Workspace A whare your datamodel is available - you can set RLS here.

 

Create a Workspace B and give Contributor access to the person whom you would like to author the reports. This person can use the Shared Dataset from Workspace A and publish / edit the reports in Workspace B. He doesn't have to touch the underlying datamodel in Workspace A.

 

You can also go through the blog post below for more info : 

https://community.powerbi.com/t5/Community-Blog/How-to-Protect-a-Dataset-from-Deletion/ba-p/818685

 

Thanks,

Nishanth.

View solution in original post

2 REPLIES 2
NishanthV Regular Visitor
Regular Visitor

Re: Setting up user who can create reports/dashboards but not edit datasets...

One Way to achieve this is 

 

Create a Workspace A whare your datamodel is available - you can set RLS here.

 

Create a Workspace B and give Contributor access to the person whom you would like to author the reports. This person can use the Shared Dataset from Workspace A and publish / edit the reports in Workspace B. He doesn't have to touch the underlying datamodel in Workspace A.

 

You can also go through the blog post below for more info : 

https://community.powerbi.com/t5/Community-Blog/How-to-Protect-a-Dataset-from-Deletion/ba-p/818685

 

Thanks,

Nishanth.

View solution in original post

WATYF Frequent Visitor
Frequent Visitor

Re: Setting up user who can create reports/dashboards but not edit datasets...

OK, it looks like this is going to work. I had to upgrade my workspace first (since I was still using the classic workspaces), but once I did that, I was able to create a Report in the "Contributor" workspace that was based off of a Dataset in my main workspace and the user could only create reports from that Dataset without modifying or deleting the main Dataset.

 

Edit: I should add that in order for this to work, you have to go to each Dataset in the "source" Workspace and grant this "Contributor" access to that dataset (using "Manage Permissions"), and make sure you check the box that grants them "build" access when you do.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors