The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
I have already implemented Dynamic RLS where possible, but in most cases it is not a feasible solution. Simply because it requires a data set to be refreshed. It is not possible to refresh the dataset everytime we add a new user to the dataset.
Nishant
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
User | Count |
---|---|
37 | |
15 | |
14 | |
13 | |
9 |
User | Count |
---|---|
46 | |
44 | |
20 | |
18 | |
18 |