Recently, I have come across the interesting scenario below, while working on a customer issue.
Issue:
I have a report with row level security (RLS) implementation; when a user logs in, they have visual filter pre-selected on the last published value, whether they can or can’t access that portion of data.
Resolution:
1.On the classic slicer, turn off ‘Single select’, turn on ‘Multi-select with CTRL’ and don’t select any value in the slicer.
2.The report will look like below:
3. Publish it to web and assign a user to the role. Once the user logs in, they can see the data only for their specific role, no multi-select available in the slicer.
Note: I have added the screenshots from Power BI Desktop for better understanding of the issue.
Author: MounikaNarayana Reddy
Be the first to comment