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.
What’s New in Dataflows and Data Integration – September 2019 Read more
Join us for the Microsoft business applications virtual launch event on October 10, 2019 for an in-depth look at the new innovations in Dynamics 365 and the Microsoft Power Platform. Read more
Power BI Desktop September 2019 Feature Summary Read more
Power BI Desktop August 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.