Get AD group Name associated for Display name of User for RLS

[cv2qm]

Hello Community,

I am trying to build RLS through AD security group, I can easily add that group in RLS security in Power bi Service. So i am trying to get Group name,Display name and User Principle Name from AD.

Can anyone guide me how can i get group name from AD. All I can see Display name and User Principle Name.

When i click on groups , it shows Nulls. 

Followed steps.

• Power Query Tab
• Click From Other Sources > From Active Directory:
• domain name
•  user table-->Loaded-> Expanded-> Display name & UserPrincipleName

Can anyone guide me to get Group name also. So i can easily assign that in Service instead of adding all users in RLS security.

Thanks!

[v-lili6-msft · Accepted solution]

hi  @cv2qm 

You may load "group" table into power bi, please refer to this blog:

https://matt40k.uk/2016/06/getting-a-list-of-ad-groups-and-their-members-using-powerquery/

Regards,

Lin