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
Developed by
- Microsoft · Organization
Is a
- Microsoft tool · Category
- Analytics and BI tool · Category
Part of
- Power Platform · Platform
Related to
- Power BI · Product
- Microsoft Excel · Product
- Microsoft Fabric · Platform
- DAX · Concept
- Power BI Desktop · Product
- Python in Excel · Product
Covered by
- Microsoft Certified: Power BI Data Analyst Associate (PL-300) · Certification
- Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) · Certification
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.