Power Query - Overview and Learning

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.

Power Query steps: 1) Connect, 2) Transform, 3) Combine, 4) Share

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 Resources

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.

How does Power Query work?

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.

How do I get 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.

Power Query Tutorials

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:

Additional information about Power Query

If you want more in-depth information on Power Query, the following resources can help:

Community, forums, and feedback

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.

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.