Forum Discussion
Return only logged on user data
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.
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
1 Reply
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