Forum Discussion
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
Helper I
Helper INo, you should still use filterRLS = 1. You just need a row per sales territory/user in the filter table.
The measure is evaluated per row of data being displayed in your visual, so as long as there's a single row in the filter table with that sales territory/user combination the measure should still evaluate to 1. This is working for me in my proof of concept.
andy_scott42
Helper II
Helper IIGreat that works perfectly. I was just unsure about how it was evaulating it.
Can I use that measure in a slicer? So it filters my slicer to only show the matching Territories?