Security log in using a SharePoint list's data

[Anonymous]

Hello,

I'm working on a report based on a sharepoint list.

In this list there is a column with the person name, I was using slicers to display the right report to the user. But the problem is that users can access other users report.

The user column is like this "Name FirstName". I was thinking of using the USERNAME() Dax function and compare it using the EXACT function with  a concat of the user column to have the email.

Sadly the USERNAME() function can't be use in a new column.

Is there a way to solve my problems?

BR,

Bastien

[v-lili6-msft · Accepted solution]

hi, @Anonymous

USERNAME() function returns the username from the credentials given to the system at connection time.

It is dynamic so you could not use it to create a column.

and for your case you could use USERNAME() function with Row-level security (RLS).

here is some reference:

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

http://radacad.com/row-level-security-configuration-in-power-bi-desktop

Best Regards,
Lin