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
praseejbk's avatar
praseejbk
Advocate I
8 years ago

As far as I know still, it was not implimented, but we can use another way to create a measure as given below

filterRLS =

CALCULATE(
COUNTROWS(Data),
Data[UserName] = USERNAME())

 

above DAX,  Data is the table name and Data[UserName] is the filed. User name format is "<domain\username>". after creating the measure you can filter using report level as FilterRLS =1.

 

it will filter according the current user.. enjoy..

 

 

  

 

  • alecthomas's avatar
    alecthomas
    Regular Visitor
    8 years ago

    I setup the measure like you mentioned, but am having troubles applying it as a report level filter.

     

    I am able to set report level filters with table columns, but measures seem to not be allowed.  I drag the measure over to the report level filter section but it will not take the measure.  Would you please explain a little more on how to do this?

     

    Thank you in advance :) - This has been a real PITA, and I wish Microsoft would just add RLS to Report Server (On-Prem).