Power Query

Product

Data connection and transformation engine with a visual editor and the M language, built into Excel, Power BI, Power Apps dataflows and Fabric.

Description

Power Query imports data from files, databases, web pages and online services, then cleans and reshapes it step by step. Every step is recorded, so the same transformation can be refreshed with one click when the source changes.

The same engine appears in several products: Get & Transform in Excel, the Power BI Desktop query editor, dataflows in Power Platform and Dataflows Gen2 in Microsoft Fabric.

Type	Product
Also known as	Microsoft Power Query, M language
Documentation	learn.microsoft.com/power-query
Licence	included in Microsoft 365

Sessions on this topic (2)

Excel for the 2020s with AI and modern tools · David Benaim · M365Con 2027
Excel for the 2020s with AI and modern tools · David Benaim · M365Con 2027

Glossary

Developed by

Microsoft · Organization

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

Power Query

Description

Sessions on this topic (2)

Developed by

Is a

Part of

Related to

Covered by

Community wiki

Experts and companies for this topic