Get members of a security group in Power BI using Power Query

Photo by LYCS Architecture on Unsplash

You may already know that there is an existing connector to your on-premise Active Directory

But what if you only need to get a list of users from a specific security group? Simply use the Power Query script below and change the domain name and the yourSecurityGroupName. You can expand the group.member if you are interested in any of the other fields ๐Ÿ˜Ž! Hopeโ€ฆ