In addition most of the features in the get transform section are now available for all users on all office plans. If you re working with excel 2010 or excel 2013 you need to explicitly download and install the power query add in.
As of this writing the power query add in is available to you only if you have one of these editions of office or excel.
How to get power query ribbon in excel 2016. In the excel options dialog box click add ins. If microsoft power query for excel is not listed in add ins list then you can download it from microsoft website. With query editor you can navigate define and perform data transform operations over a data source.
In excel click the file tab. Organization for power query 2 10 range of data sources include enterprise shared queries. If you are using excel 2016 go to the data tab on the ribbon and press the new query button to create a query and open the power query editor.
My shared range of data sources include my shared queries. Power query tab will added to the excel ribbon. You can access power query from the power query ribbon in excel.
From the get external data section in the power query ribbon tab select from other sources blank query. If you are using excel 2013 or earlier versions of excel you may need to enable power query in excel. Microsoft released power query and power pivot as excel add ons in 2010 but these features are now standard in excel 2016 under the get.
Filters your search based on a query or table attribute. Click on add ins then select microsoft power query for excel and click ok. Power query is no longer an add in but is a native excel feature from the data tab under the get transform section.
Filters your search by range of data sources. From the context menu select options. In excel 2016 the power query commands are found in the get transform group on the data tab.
You can also download and install the most recent version of power query for excel which automatically enables it. If microsoft power query for excel add in is not listed among the add ins. Power query is available with all levels of office 365 subscriptions.
In excel 2016 we integrated the power query technology and experience into excel. All apply a search term for all scoped data sources. Here is an article that explains the features available for each subscription level.
Power query is an excel function that allows you to import data from a variety of sources excel tables csv files online database etc and easily reconfigure the data into a pivot table in a spreadsheet.