Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kumsha1
Post Patron
Post Patron

Ignore RLS security on one page of the report

Hi,

 

We have a report with 2 tabs Overview, Department. RLS was implemented so that user logged in can only see their correspodning department data, however few users need to see all department data on Overview page. We have a table filter DAX in manage roles that filters out the user department. Can this filter be ignored at individual page level to get the desired results.

 

Ex: User sam belongs to department A and with current RLS setup he can only see A data on both tabs, can we ignore this filrer on Overview page, so sam can also view other departments data? but only see A department data on Department page. Both pages are populated from same table.columns / measures.

 

Thanks in advance for your help !

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @kumsha1 ,

 

You cant ignore the RLS,but you can duplicate the table which acts like you can set 2 RLS for one report.It is a workaround.Steps see below:

Duplicate your report,then create the visuals you need.Set RLS in page1.Then hide the deplicated report.

 

See an example below:

I create a table and a visual as below:

Annotation 2020-06-19 124228.png

Then I duplicate the table using below dax expression:

 

Table 2 = 'Table'

 

And set a RLS in page 1:

Annotation 2020-06-19 124503.png

While testing you will see:

page 1page 1page 2page 2

 

For the related .pbix file,pls click here.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

Hi @kumsha1 ,

 

You cant ignore the RLS,but you can duplicate the table which acts like you can set 2 RLS for one report.It is a workaround.Steps see below:

Duplicate your report,then create the visuals you need.Set RLS in page1.Then hide the deplicated report.

 

See an example below:

I create a table and a visual as below:

Annotation 2020-06-19 124228.png

Then I duplicate the table using below dax expression:

 

Table 2 = 'Table'

 

And set a RLS in page 1:

Annotation 2020-06-19 124503.png

While testing you will see:

page 1page 1page 2page 2

 

For the related .pbix file,pls click here.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 Hi Kelly,

I have tried this option and it works fine, however just wanted to check here if there is any oher option just to ignore the RLS at run-time. Most probably we will end up implemeting this option only. Thanks for your reply 🙂

Cheers,

Anonymous
Not applicable

Hi  @kumsha1 ,

 

Sorry to say that RLS acts like a report-level filter,it cant be ignored once it is running and it will applied in all pages.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
amitchandak
Super User
Super User

@kumsha1 , you may create a table, on which you do apply RLS filter ?

AllisonKennedy
Super User
Super User

RLS is designed to add security to the data, sounds like what you are wanting is just a filter. You can't ignore RLS on a page, but you can give Sam access to all departments using RLS and then put a filter on the Dept page that chooses Sam's department.

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

sounds like what i am trying to do, can you pls suggest what kind of filter will suffice the requirement in this case?. Thanks.

The filter would look similar to what you had on RLS previously, but applied as a page level filter.

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

 

Helpful resources

Announcements
Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors