Forum Discussion

nitin_goel05's avatar
nitin_goel05
Regular Visitor
8 years ago

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...
Report Server
Report Server On premises
security
andy_scott42's avatar
andy_scott42
Icon for Helper II rankHelper II
7 years ago

Thanks davidm5.

 

So if I have a person with 2 territories in the Territory table how will this filter display both territories? 

 

So for example, if I have a pie chart and want to filter it to only show the regions the user has in the SalesTerritoryRLS table, I would set the filter to filterRLS >= 1?

 

Thanks.

davidm5's avatar
davidm5
Icon for Helper I rankHelper I
7 years ago

No, 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.