Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
cv2qm
Helper I
Helper I

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

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!

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.