Forum Discussion
nitin_goel05
8 years agoRegular Visitor
Row Level Security in Power BI Report Server
Hi, I am trying to implement 'Row Level Security' in Power BI On premise-solution 1. Creating roles in 'Microsoft Power BI Desktop for Report Server - October 2017' works fine in desktop but then th...
davidm5
7 years agoHelper I
I think what you want is to have a slicer that shows only the sales territories that the logged-in user is allowed to see, that you want to do that by showing the sales territory in the slicer and filtering the slicer using the filterRLS measure. Problem is that you can't put a visual filter on a slicer.
There may be some kind of hack or workaround, but not one I'm aware of off hand. Best I can think of is instead of a slicer, having a table that lists all the sales territories and when the user clicks on a row in that table it filters everything else on the page.
andy_scott42
7 years agoHelper II