Connect to Active Directory (Power Query)

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.

  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.

Power Query Data Sources

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!