Forum Discussion
Dynamic RLS
renanpinheiro,
Add another email address column for the instructors in your table, then use USERNAME() function to implement dynamic row level security as described in the following similar blog.
http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
Regards,
Lydia
Hi there,
Can you tell us please what table name and column name do you use in your SQL table?
My roll is based Departments like |22|24|44| and user principle assigh to these rolls
Thanks
Oded Dror
Anonymous I'm not sure I understand your question fully.. The calculated column MgrPath = PATH([user_id],[user_mgr]) is set in the USERS_REVERE table. It uses two columns that come from a sql query, user_id and user_mgr. the PATH function creates a | delimited string showing that user's managerial hierarchy.
Then the VLOOKUP and PATHCONTAINS functions simply looks for the current logged in users name in that string. If their name appears then any data related to that record will show for the user.
Tadder,
Thank you
Oded Dror