Row Level Security Problem and D365 Time Entries

Hi All,

I want to but reports for users to shwo their historical time entries taken from D365 Project service.

I have loads of reports built from this data already but this is the first time I have tried to use RLS.

Basically, I want users to see a report that just shows them their time entered and the projects they work on.

When a user logs into the Power BI service they should only see their data in the report.

So far I have brought in that data and built the reports and it all looks fine but when I apply the RLS nothing appears

or sometimes when I test it I still see all of the data not just user specific data.

I'm using the UserPrincipalname() against the email address column I have in the time entries table, my thinking is that

when the logged in user is identified then it will only show the entries in the rows with the username email address.

Is this correct? 

It might also be related to the relationships, however I don't seem to have the option to enable security both ways.

Any ideas welcome.

Jason