Skip to main

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

Power BI Desktop October 2019 Feature Summary 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

What’s New in Dataflows and Data Integration – September 2019 Read more

Power BI Desktop September 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.

Power BI

Connect, clean, reshape and import data faster.

Learn more


Seamlessly import, transform and analyze data in Excel.

Learn more

Common Data Service

Auto-refresh data from a wide range of sources.

Learn more


No SQL coding skills required.

Learn more

Analysis Services

Reshape and transform data to suit your model.

Learn more
various data dashboards

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.



Microsoft SQL Server




Dynamics 365

Azure Data Lake Storage