Office Group used for giving permission has members from a different level

[syasmin25]

Hello,

I have set up security for levels A and B. Level A has access to limited things within their department of the building, whereas level B has access to everything within the building that they are addressed to. I have an office group for level A which contains both Level A and Level B user. And, I have a separate office group for Level B. I have given them separate types of limitations and have tested out for Level B and its worked perfectly. However, once I implemented Level A's roles, it started to work for Level A, but stopped working for Level B. Level B now seems to have access to everything. Is there any possible way I can stop that from happening? Please let me know.

[GilbertQ · Accepted solution]

Hi there

The reason to me is because you have an Group 1 with has got users from A & B. And Group 2 has got users only from B.

Now when you add group 1 and group 2, the users in B get access to both Group 1 and Group 2.

You need to create group 3 which only contains users from A.

And then only include Group 2 and Group 3

[syasmin25]

Thank you, this makes sense. I was thinking if there was a way I would be able to make PowerBI give user the maximum permission if their ID is in both the groups.

[nickyvv]

@syasmin25,

can you be a little bit more specific about your types of limitations?
Did you implement Row-Level Security, workspaces roles, app access?