Forum Discussion
Row Level Security and Roles
I have a table called Cost_Centre, within that table I have a column called UPN which is the UPN of the cost_Centre manager. This column can have multiple values in it. For example I have placed the ...
Try this instead for your RLS filter. If performance poor, you could alway split your text into a list with Text.Split and expand that list to new rows and use your simpler filter expression.
CONTAINSSTRING(dim_CostCentre[UPN], USERPRINCIPALNAME() )
Pat
Hi Pat
Went back to CONTAINSSTRING and worked perfectly as far as I have tested it.
My issues was I was running on Analysis Services 2017 - upgraded to 2022 and it worked.
I think 2019 would work as well.
Cheers