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.
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 👍
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |