Forum Discussion
Row Level Security - Effective User Name
Hi Anonymous ,
You could try to define the RLS in SSAS model, and test this whether it work or not. You could create a user table, which contains effective name, domain\username and corresponding value which it could view(use USERPRINCIPALNAME ( ) in RLS), then connect to fact table or dimension table, and set RLS in model to see whether it work or not. And when you publish it to service, you also need to map effective name on domain\username in datasource You could refer to Implement row-level security in an Analysis Services tabular model for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
You could try to define the RLS in SSAS model, and test this whether it work or not. You could create a user table, which contains effective name, domain\username and corresponding value which it could view(use USERPRINCIPALNAME ( ) in RLS), then connect to fact table or dimension table, and set RLS in model to see whether it work or not. And when you publish it to service, you also need to map effective name on domain\username in datasource You could refer to Implement row-level security in an Analysis Services tabular model for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.