Dynamic RLS with Azure Active Directory Isn't working Properly (sometimes)

[Asalk]

Hello,

I'm using Dynamic RLS on one of our financial reports, and i'm facing some issues when sharing the report with end users. Some users are able to see all data instead of the applied RLS. I suspect that RLS takes some time to get distrubted between users. However, I can not find anything that confirms this theory. All of them have read access to the report. there is no difference between the users. I'm adding Azure Distrubtion group to the RLS on Power BI services (e.g. [email protected]). 

the RLS Formula i'm using is :

PATHCONTAINS(
'Staff Data'[Path],
MaxX(
            Filter( 'Staff Data',
                        [Email]=USERPRINCIPALNAME()
                         ) ,
                        'Staff Data'[Employee_Number]
        )
)

It worked before on one of our other reports, but i did face the same issue initially where users were able to see all data but with time around a day or two, it actually filtered the data for them.

any help is greatly appreaciated.

[v-robertq-msft]

Hi, @Asalk 

Thank you for the experience sharing of changing the relationships between tables to fix this problem, would you like to mark your own reply as a solution so that others can learn from it too?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Asalk · Accepted solution]

I managed to fix it by re-adjusting one of the relationships we had from many-to-many to one-to-many, apparently there was some issue if a user was found in two different RLSs. Power BI just platently gives up, and handsover all the data 😅... 

Anyways, hope this helps out someone eventually.

Best,