Row Level Security

[Anonymous]

Hi,

I am trying to implement Row Level Security, based on the Column "User Access". But the challenge is that the column might have two users seperated by a delimiter (in this case $). I tried using contains keeping in mind that if the "User Access" column contains userpinciplename the record should populate. But it seems that it's not working that way. Below is the dataset and the measures I have used. Also attached the scren shot of the dashboard.

Order Date	Last Ship Date	Expected Ship Date	Value	User Access
01-01-2018	01-01-2018	01-02-2018	1
01-05-2019	02-06-2019	01-02-2018	2	ABC@XYZ.com
02-06-2019	01-10-2019	01-02-2018	3	ABC@XYZ.com
01-07-2019	01-10-2019	01-02-2018	4	ABC@XYZ.com
01-08-2019	01-10-2019	01-03-2018	5	ABC@XYZ.com # XYZ@XYZ.com
01-09-2019	01-10-2019	01-03-2018	6
01-10-2019	01-10-2019	01-04-2018	7
01-11-2019	01-11-2019	01-03-2018	8
01-12-2019	01-01-2020	01-03-2018	9

Measures Used:

CurrentUPN = USERPRINCIPALNAME()

IsCurrentUPN =

IF (

CONTAINS (Sheet1,Sheet1[User Access],[CurrentUPN]),

TRUE(),

FALSE()

)

Does anyone have a solution/alternative for this?

Thanks

[TomMartens · Accepted solution]

Hey @Anonymous , 

just use this DAX expression in the manage role section:

containsstring('<your tablename>'[user access] , userprincipalname())

Please be aware that the USERPRINCIPALNAME() and USERNAME() might return different results on Power BI Desktop and in Power BI Service.

Hopefullly this is what you are looking for.

Regards,

Tom