Return only logged on user data

[send2mark]

The format of the column is LastName, FirstName and I only want the logged on user to see their own data. So far the best way I am seeing is to us the Managed role options, but I can't see to find the correct expression to do this.

There is also a column that shows the user unique identifier in the table if that makes it easier.

[amitchandak · Accepted solution]

@send2mark , for that you need to have a table with email and what access you want to control and implement RLS

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

Power BI- Row Level Security(RLS): Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc