Users email not filtering through the data via RLS - potential service permission issue?

[Anonymous]

Dear community,

We have a model design in SSAS that is then queried via live connection.
The model contains a users table that we use to regulate who accesses what data, as seen below:

The DAX used to filter data is:

=PATHCONTAINS(Users[ManagementPath],
MaxX(
Filter(
Users,
[Email]= USERPRINCIPALNAME()
)
,Users[EmployeeNumber]
)
)

Now i was wondering if it is some issue because of Service permissions ? Because we tried the following so far:

1: Validated users email / principalname because the users group comes from Azure Domain, and we verified there are no domain changes.

2: We chaged the user A email to someone elses (user B with exact same domain) and the User B could see all the data clearly, so we assume the data relationships and row filters work.

3. The interesting part is that users table is used to also filter other tables and it works for the user A on overview report, the only part that doesnt filter data (shows all  blank) is on drillthroughs.

Happy for anny suggestions

[Anonymous]

You could create a report that is just what the drill thru page contains and test that alone with each user. I know it is not an answer, but it is a path to debugging issue. Especially, since every thing else works.

Also, place the USERPRINCIPAL in a measure and display on erach page to see if something is up with the matching names.