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 July 2019 Feature Summary Read more

Power BI Desktop June 2019 Feature Summary Read more

You Asked for It: A Journey to Power Query in Excel for Mac Starts Now! Read more

Last Chance! Register for Microsoft Business Applications Summit 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
mc-excel-logo-cards

Excel

Seamlessly import, transform and analyze data in Excel.

Learn more

Common Data Service

Auto-refresh data from a wide range of sources.

Learn more

Flow

No SQL coding skills required.

Learn more

Analysis Services

Reshape and transform data to suit your model.

Learn more

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.

mc-excel-logo-connector

Excel

Microsoft SQL Server

Folder

Sharepoint

Oracle

Dynamics 365

Azure Data Lake Storage

CubeDatabaseLarge_64

SAP HANA

Salesforce