Row Level Security With USERPRINCIPALNAME()

[Vick143]

Hi Everyone,

We have one master dataset in which we use EmailAddress = USERPRINCIPALNAME() for our row level security. There are multiple reports using our master dataset and we have to create one more report using the master dataset but we can not have security on that report(All users should be able to see full data). Is there a way to create a switch where we can enable and disable security on the report? I tried following formula but it did not work. 

[EmailAddress] = IF(ISFILTERED(Security_tbl[Status]),"Global.User.com, USERPRINCIPALNAME())

Security_tbl is stand alone table and it has only one column 'Status' and one value "off", my idea was to bring it to filter on all pages on my report and filter it so users can see full data for this particuler report. Global.User.com is dummy email and I added it on ProfitCenterUser file and it is given full access. 

Thank you very much in advance for looking into it 

[lbendlin]

The standard approach is to add a shadow copy of your fact tables to the data model, with sensitive information removed/aggregated away and RLS not applied.