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

Disable RLS in reports using dataset with RLS

Hi!

 

Instead of having to maintain multiple datasets to different reports I am making one big dataset which I connect my reports to. In this dataset I have RLS which is needed for most reports, but I would like to have some reports without RLS but still use the same dataset.

 

Is there a possibility where I can use the same dataset or do I have to make a copy and then remove RLS in the copy? I hope to avoid the latter since I then have to either do things twice (when I alter the dataset) or having to make a copy each time.

 

Best regards,

Tormod

1 ACCEPTED SOLUTION

HI Tormod_GK,

 

Do you mean you want different pages have different role? The different pages belong to one report(dataset) and you can only assign one role to one dataset. To achieve your requirement, I'm afraid you should rename your pbix file and publish again so that you have two datasets which can be assigned with two different roles at the same time.

 

Regards,

Jimmy Tao

View solution in original post

7 REPLIES 7
Stachu
Community Champion
Community Champion

by "without RLS" you basically mean access to all of the data? why not create a role that has access tor everything?



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Super User!

Tormod_GK
Frequent Visitor

Hi!

 

Then the persons in this role would see everything in all other reports as well. I like to use RLS so that they see figures that are important to them, especially in the dashboards. But in some reports (benchmark/comparison) I would like the same persons to see everyting. So I was hoping that I could skip using RLS in some specific reports.

HI Tormod_GK,

 

Do you mean you want different pages have different role? The different pages belong to one report(dataset) and you can only assign one role to one dataset. To achieve your requirement, I'm afraid you should rename your pbix file and publish again so that you have two datasets which can be assigned with two different roles at the same time.

 

Regards,

Jimmy Tao

Do I need to remove RLS in the renamed file?

Hi!

 

Yes something like that. Having some reports that use the same dataset with RLS, but without using RLS. Like a feature when making the report, like saying "disable RLS in this report" 🙂

 

But I expected that I must do this the hard way, meaning making a copy, delete RLS and then publish. It will just take a bit more time to maintain and do changes in the dataset (since I want them to be exactly the same).

 

Best regards,

Tormod

 

 

Hi Tormod_GK,

 

Have you solved your issue? If you have, could you kindly mark my answer?

 

Regards,

Jimmy Tao

Yes, but was just hoping for a different solution 🙂

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors