Forum Discussion
Need to create RLS for Existing Active directories groups
dilkushpatel thank you .. Now i am geeting some ideas
Can you please give the steps to import the users and groups of AD to power BI and how we can make relationship with our charts?
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