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…

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store