cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
othy_bi
Resolver V
Resolver V

Clear Slicers in RLS Context

Hi Community,

Scenario: I have a one page report which is auto-filtered based on RLS, to this page, I have added many slicers with an option that allows the user to clear all of them.

Issue: Here comes the issue,  when user1 is connected he can see only his data, but when he clears the slicers then all data shows up.

Is there any method to use clear all slicers as a bookmark while applying RLS ?

 

You are reading this message ? Any suggestion from you would be appreciated 👍

1 REPLY 1
m3tr01d
Resolver III
Resolver III

@othy_bi If he can clear the filter, it means that the RLS is not working properly...
If RLS is applied correctly then there's no way for a user (with viewer role) to view other data then his own data.

It would be good to give us a visual of what do you mean by "all data shows up" and also
a screenshot of your data model with the relationship and RLS Table

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!