Forum Discussion
RLS based on user login
Hello, Anonymous,
in your RLS settings to your RLS table, write [EMAIL]=USERPRINCIPALNAME().
Then create a new column which weill be concatening Company and Dept together (this is optional, you can use as the key any of those withour creating new one), do it in your MAIN Excel and your RLS table, then create relationshisp Many to Many but don't make it both, but RLS filters MAIN EXCEL, key column is the new one.
and then whenever you use Company or Dept, use it from the RLS tabel as dimension.
Hi Anonymous
Please find the video to details - https://www.youtube.com/watch?v=jphj40tBPD8
Please implement RLS in DOMAIN EXCEL table as explained in video. Create relationship with COMPANY column or or other lookup column.
If solve, mark as solved
i have done the same with respect to "COMPANY" that is an active relationship in my model, but i also want power bi to filter the data according to DEPT as well
i have tried to use LOOKUPVALUE but it does not seem to work
how do i make power bi check the dept associated with the user's email and show only that data