Dynamic RLS for Org structure

on power bi desktop when setting the roles you should be able to spacify multiple varues for one user ( you need a column in each table that works as a filter control for the data) :

basically you can set for each table a column filter to allow or not data to be seeing by that role, 

so you by giving a role a value null for example for that column wont be able to see the data on it, if you using a department id column for example you can do multiple rows to specify in each row each posible value the role have access to: 

them in your power bi service you set up to wicth account each role its assigned, you could create a adress security group and add the users to it and assign the role to that users group, so anytime you add or delete someone from it the permits of those role get assigned without getting in power bi service to configure. 

hope this its of help,

if this solve your consult please accept as solution, so others can find it if usefull, 

thanks. 

hey Anonymous  did it work?

hey @hewavij  did it work?