Connect to Active Directory (Power Query)
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.