Forum Discussion
Need to create RLS for Existing Active directories groups
Hello, I am aware that we should have Desktop Pro inorder to implemet Role level security(RLS) but i need some clarity on the below queries: 1. Our client told they need RLS to their reports...
importing is OK for the short term but I'd be interested in ways to make that link dynamic.
Today I have a table in Power BI with all my users and the groups they belong to.
Using the username() function I can get their username, then relate it to their group(s) and filter the data accordingly.
but maintaining that user+group table is tedious and error prone so it would make more sense to rely on AD.
and it only makes sense if we can do it dynamically, with a function that would return the list of groups/roles in AD the current user is associated with.
I actually found how to achieve this and documented it in https://community.powerbi.com/t5/Desktop/How-to-leverage-Active-Directory-to-filter-the-data-in-Power-BI/td-p/140479