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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DataVitalizer
Super User
Super User

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
Continued Contributor
Continued Contributor

@DataVitalizer 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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.