How to apply RLS on AD groups which are not in O365

[Anonymous]

Hi All, I have created a dashboard which would be shared with a lot of folks (~600 people). However, I don't want to show the complete data to everybody and show only the relevant part, and hence, I am using RLS to achieve this But the concern is it will be difficult to add all these people manually (and also if anybody new comes in at a later stage who also wants to look at the dashboard). Hence, the clients have given me an AD list where they have the required members added in the active directory group. And these groups don't have any email id like structure. These AD groups are just created in their server.  Can I, by any means apply RLS on those groups which don't have an email like structure, or what should be the additional thing that I should ask for from the clients?

Thanks in advance,

Regards,

Rohan 

@amitchandak @Greg_Deckler @parry2k @Cmcmahan @Icey @euniceyau 

[v-juanli-msft]

Hi @Anonymous 

Please check if the methods from links below help:

https://community.powerbi.com/t5/Desktop/How-to-leverage-Active-Directory-to-filter-the-data-in-Power-BI/td-p/140479

https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/

You could find which groups can be added to use RLS.

https://www.fourmoo.com/2020/04/01/power-bi-which-groups-can-be-used-to-set-permissions-in-power-bi/

Best Regards

Maggie