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
I appreciate that this is by design.
I was hoping for more of an automated solution to manage users.
I have looked into using SSMS 18.0 and AMO but neither seems to be allowing me to manage roles. I hope there will be something in the near future to automated RLS. Given that the team is focusing on bringing new features specially for large Enterprises, I am surprised that this hasn't been look at.
Thanks for your help GilbertQ
Hi there
If you do use AD Security groups you can have it all automated, but as always with any technology you will have to get the data updated in order to get new changes applied.
If you do use AD Security groups you can have it all automated, but as always with any technology you will have to get the data updated in order to get new changes applied.