Forum Discussion
Solved
Row level security using AD groups
Currently I have RLS applied on my model allowing users to access certain level of access based on a mapping table I have maintained. My mapping table is of the the below schema storing the UPNs of u...
On Power BI Service, you can add security group as member of a role. See: Row-level security (RLS) with Power BI
In this scenario, you can create security groups on O365 admin center: Create, edit, or delete a security group in the Office 365 admin center. Then add all users into corresponding security group. Now you will not need that "mapping" table in your model.
Regards,
Just finished testing and was able to confirm that individual members of an AD group can be assigned to different RLS roles. Sharing to the AD group gives members access to the report but the RLS role an individual is assigned is what determines what data the user sees.
How do i achieve this?. Any documentation available?.