Forum Discussion
XMLA end point and row level security (RLS)
Hi, Is it possible to manage row level security in power BI service using XMLA end point with SSMS or something similar? I would like to create our amend roles, add or remove users etc Thanks
Thanks.
Managing RLS is very manual in the PBI service and is not helpful in our organisation which has over 30000 employees. If you can recommend anything that would be great.
Thanks
Managing RLS is very manual in the PBI service and is not helpful in our organisation which has over 30000 employees. If you can recommend anything that would be great.
Thanks
Hi there
There is Dynamic RLS in which you can define a single role and the RLS is applied dynamically where you can do it via AD Security Groups
Here is my blog post on how to achieve this: https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/
There is Dynamic RLS in which you can define a single role and the RLS is applied dynamically where you can do it via AD Security Groups
Here is my blog post on how to achieve this: https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/