Connect to Active Directory

  1. In the POWER QUERY ribbon tab, click From Other Sources > From Active Directory.
  2. In the Access an Active Directory Domain dialog box, click Windows authentication or Basic authentication. For Basic authentication, enter your Username and Password.
  3. Click Save.

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.

Applies to:
Excel 2013, Excel 2010