Note: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.
In the POWER QUERY ribbon tab, click From Other Sources > From Active Directory.
In the Access an Active Directory Domain dialog box, click Windows authentication or Basic authentication. For Basic authentication, enter your Username and Password.
After the connection succeeds, you can use the Navigator pane to browse all the domains available within your Active Directory, and drill down into Active Directory information including Users, Accounts, and Computers.