based on what you described, you are unable to see the “user” in the security group for level 2? What I understood from above is that for example let us take following scenario,
SG1 – security group 1
SG2 – security group 2
Now assume we have three employees,
Sam, Brian and Ansh
Sam is the boss so let is add him to SG1
Brian is in SG2
Ansh - regular employee with no manager level access,
Ideally, the RLS is provided to a username and in the Power BI Service we will specify which security group to add and apply this RLS to.
So if we add SG1, then only Sam will be able to see the data, and if we add SG2 then even Brian will be able to see the data.
If the combination is applied, SG1 and the user Brian then Brian will still be able to see all the data and Brian will not be a part of SG1.
Based on your original ask, “I had a question, I have a users as level 1 in the RLS file. However, for email groups, the user is in both a level 1 email group as well as level 2 email group.” the logic is as mentioned in my previous reply.
However there is another unique scenario where an employee is not part of the SG but has been added explicitly to the RLS (explained in this post above)
Hope this clarifies