Row Level Security Problem and D365 Time Entries

[JayPow28]

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

[Anonymous]

Hi @JayPow28 ,

Glad to know your issue has been resolved ! Please kindly Accept your post as the solution to make the thread closed. 😀

Thanks in advance.

Best Regards,
Eyelyn Qin

[selimovd]

Hey @JayPow28 ,

did you also test the roles with your email or different email adresses:

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[JayPow28 · Accepted solution]

Thanks again,

I checked it again and it was a filter I had on my visualisation that was catching me.

I removed the filter and it worked.

To be clear, it was a filter based on names I had in the visualisation that was blocking the RLS filter from working. Check your filters 🙂

Jason

[JayPow28]

Thanks, I'll check this out and get back to you.

Jason