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 for the link. I have gone through the blog and it explain how to connect using XMLA endpoints. Do you know how to extract the information once I have connected using SSMS?
Thanks
- Hi there
You can connect with Excel, I have not created a blog post on how to do it yet, but it is in my plans- 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/