Row-Level Security Single User in multiple roles is not working

[Anonymous]

Hi,

I have performed the Row Level Security and it's working partially not 100%. The problem which I am facing is,

if Single user in multiple roles the report not showing anything. If Single user in single Role it's working fine.

Group	Users
A	User1@XXX.com
A	User 2@XXX.com
B	User 2@XXX.com
B	User 3@XXX.com
C	User 4@XXX.com
C	User 5@XXX.com
D	User 6@XXX.com
D	User 1@XXX.com

Here, I created roles likes A,B,C,D

Report Error Screenshot:

When I try to login by User1@XXX.com I seen below screenshot in Power BI Service. Also, I have added the Users in Row-Level Security.

How to resolve this issue?

Thanks,

Lawrance A

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

Please check if below article could help.

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

For 3rd party Links:

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Regards,