Forum Discussion
Need to create RLS for Existing Active directories groups
If your dataset has some user table which has all this users in there then you can lookup for embedding with filters and then it will be matter of finding logged in user which should be possible in sharepoint i guess and then pass that user name as filter to report.
Also I think it is possible to apply RLS with groups
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
Check Working with members section
"You can add a member to the role by typing in the email address, or name, of the user, security group or distribution list you want to add. This member has to be within your organization. You cannot add Groups created within Power BI."
Hello first i will thank u for ur reply dilkushpatel
In my case I want dynamic groups i.e i dont want to maintain a data sources of the users as like another table and create a relationship with main data source inorder to works as a filter.. becuase if any new user comes/ old user has to be remove we need to be do it manually...
So We already had dymaic AD groups with lots of users i just wanted use them in my Report for RLS .. is there way to do that..
Please suggest regarding this..
You will be able to add your groups to RLS settings but how will power BI know what data to show for this user?
Usually how it works is we have one user table which will get filtered by logged in users id and then rest of the tables will get filtered due to relationship and a result you see needed data.
You can always import data from your active directory into SQL and ultimately into Power BI (unless there is a direct way which I do not know).
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?
