Data prep done smart, fast, easy
Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.
Data prep done smart, fast, easy
Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.
Join us at the Microsoft Business Applications Summit on May 6–7, 2020, for an in-depth look at new innovations across Dynamics 365, Microsoft Power Platform, and even Excel. Read more
Power BI Desktop December 2019 Feature Summary Read more
Power BI Desktop November 2019 Feature Summary Read more
Power BI Desktop October 2019 Feature Summary Read more
What is Power Query?
Microsoft’s Data Connectivity and Data Preparation technology that lets you seamlessly access data stored in hundreds of sources and reshape it to fit your needs—all with an easy to use, engaging, no-code experience.
Connect to hundreds of data sources
Power Query supports hundreds of data sources with built-in connectors, generic interfaces (such as REST APIs, ODBC, OLE, DB and OData) and the Power Query SDK to build your own connectors.
Accessible, powerful, smart data preparation
Access more than 300 transformations in the Power Query Editor, letting you transform data easier and with more flexibility than any other tool—including smart AI-based data transformations.
No coding needed
Anyone can start connecting, cleaning, transforming, and combining data today—try it and see.
Everything becomes more powerful
We’ve seamlessly integrated Power Query into many popular Microsoft products, making them easier to use in order to help customers unlocking results faster.
More proof of the power
Reuse your Power Query work
Create reusable data connectivity and preparation logic—even create parameters—and make adjustments to the logic across projects, all without any coding.
Learn it once, leverage across many products
Power Query works across several Microsoft products, so whatever you learn for Power Query in Excel can be applied to Power BI and other products.
Custom connectors
Easily extend Power Query by creating your own connectors and data transformations if you need to, that can also easily be shared and used by others.
Open your data to more customers
Now anyone can easily build custom connectors and transformations, then share them. If you own a data source or service and want to make it easily accessible to others, check out how to build and certify your custom Power Query connector.