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.
Feb 15, 2016 - Enable Power Pivot in Excel 2016 - Tutorial: Provides an overview, instructions, and a video lesson on how to enable the Power Pivot add-in in. What’s new in the June 2016 Power Query Update. The four new features are. Download the June 2016 Power Query update. You can pick it up from Microsoft’s site here. They are pushing earlier to 2016 than 2010/2013. (To my memory, this is the first time we've got an update in Excel 2016 before 2010/2013, even though we've know that is. Power Query is a new add-in that was introduced in Excel 2013 by Microsoft. Will need to click on the following link and download the Power Query add-in. Oct 19, 2015 Learn how to import multiple Text Files (.txt) from a folder into Excel using the new Excel 2016 Power Query: Data Ribbon Tab, Get and Transform group. Download Excel.
Note: Query Editor is part of Power Query. For a quick video on how to display Query Editor, see the end of this article.
Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, and more.
Interested in seeing Power Query at work? The Power BI - Getting Started Guide has a section that shows Power Query being used to create a workbook that connects to external data, transforms data, and creates a data model. You can read the entire guide, or jump to its Power Query section.
With Power Query, you can share and manage queries as well as search data within your organization. Users in the enterprise can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting. For more information about how to share queries, see Share Queries.
Find and connectdata across a wide variety of sources.
Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as Power Pivot and Power View.
Create custom views over data.
Use the JSON parser to create data visualizations over Big Data and Azure HDInsight.
Perform data cleansing operations.
Import data from multiple log files.
Create a query from your Facebook likes that render an Excel chart.
Pull data into Power Pivot from new data sources, such as XML, Facebook, and File Folders as refreshable connections.
With Power Query 2.10 and later, you can share and manage queries as well as search data within your organization.
Web page
Excel or CSV file
XML file
Text file
Folder
SQL Server database
Microsoft Azure SQL Database
Access database
Oracle database
IBM DB2 database
MySQL database
PostgreSQL Database
Sybase Database
Teradata Database
SharePoint List
OData feed
Microsoft Azure Marketplace
Hadoop File (HDFS)
Microsoft Azure HDInsight
Microsoft Azure Table Storage
Active Directory
Microsoft Exchange
The Query Editor only appears when you load, edit, or create a new query. The following video shows the Query Editor window appearing after editing a query from an Excel workbook. To view the Query Editor without loading or editing an existing workbook query, from the Get External Data section in the Power Query ribbon tab, select From Other Sources > Blank Query. The following video shows one way to display the Query Editor.
Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop.
Using Power Query often follows a few common steps.
While some data analysis efforts focus on a few of these steps, each step is an important element of Power Query. For more about information, and to see an example of these steps in action, see Getting Started with Power Query.
Power Query is one of three data analysis tools available in Excel:
Power Query
The following links and information can get you going with Power Query. The sections and the links are presented in the order you’d need if you were just starting out – the first link describes where to get Power Query, the next section gets you to a Getting Started Guide, then tutorials, and community connections.
We update these links when additional resources are available, so check back often.
With Power Query you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports.
To see Power Query in action, take a look at Getting Started with Power Query.
Power Query is available as a download for Excel 2013 and 2010. The underlying Query technology that enables Power Query is also found in the Power BI Desktop, which is part of the overall Power BI offering from Microsoft.
Select the following button to download the current Power Query release:
You can also see what’s new in 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.
Seeing Power Query in action can be a boost to learning how to use it. Here are a few tutorials that can get you started, and show you examples of how to use Power Query:
If you want more in-depth information on Power Query, the following resources can help:
There are all sorts of people using Power Query, and they like to share what they’ve learned. Take a look at the following resources to get involved with others in the Power Query community.