Forum Discussion
RLS issue
I have a power bi report where employees are allocated to departments. So Mrs Smith is allocated to Science. The head of Science is then given access to all the science data. However, Mrs Smith is al...
IHam , refer this code , This allowing one email to have all access, another email to in file having all values
[email] = userprincipalname() || userprincipalname() = "[email protected]" || userprincipalname() in summarize(filter('Brand Sec', 'Brand Sec'[Brand] = "All") , [email])
this is rls table data filter item table on brand
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
Many thanks for your time on this - I think I understand. Will give it a go and let you know.