Share via

Excel 2016 Query Data from Active Directory

Anonymous
2015-12-17T06:12:51+00:00

In Excel 2013 with the Power Query component, Get External Data included sources such as 'From Active Directory' and 'From Microsoft Exchange'.

With Excel 2016, Power Query is 'built in' and not a separate product; however I cannot find how to connect to those 'other sources'. The available options are limited as below. In particular I need to connect to data from Active Directory.

If I launch the Query Editor and try to add a datasource there, the same limited list is presented.

Is there some other component or addin that I need to install?

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-12-17T08:23:58+00:00

    Hello,

    Welcome and thank you for posting your query in Microsoft Office Community.

    As the issue is with Power query with the Excel, you may post your query in Excel IT Pro for further assistance:

    https://social.technet.microsoft.com/Forums/office/en-US/2daccafe-13b1-4009-96ad-e58f8adcb5b9/excel-data-add-values-if-other-values-are-equal?forum=excel

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    If you have any other questions related to Office products, you can always reply and I’ll be happy to assist you.

    Thank you.

    1 person found this answer helpful.
    0 comments