Forum Discussion
Global Row-Level Filtering without manually assigning security roles
Not sure about your company but we have PDLs that cover all employees. That's what you usually assign to that single role.
Read about the difference between static RLS (roles) and dynamic RLS (reference tables)
I do have dynamic RLS, see the second paragraph of context. It still requires having at least one security role containing all these users, which means adding all those users to that role.
The issue isn't adding users to individual roles, but adding users in bulk at all. Essentially, what I need isn't just Dynamic RLS, I need Dynamic Role Membership too, and MS-Teams groups don't seem to work. They work for Report or Dataset Permissions, but not for Security for whatever reason.
Not sure about your company but we have PDLs that cover all employees. That's what you usually assign to that single role.
So it's just that Teams Groups don't count as groups for the security role, even if they do count for the report permissions? I admit I don't understand the distinction, nor do I know that side of administration, but I'll talk to our domain administrators and see if they can help me out on that.
Thanks for the pointer!