Power Query documentation

Power Query is the data connectivity and data preparation technology that enables end users to seamlessly import and reshape data from within a wide range of Microsoft products, including Excel, Power BI, Analysis Services, Dataverse, and more.

Power Query Overview

Overview

• What is Power Query?
• What are dataflows?

Using Power Query

How-To Guide

• Use Power Query
• Get data
• Transform data

Working with dataflows

Concept

• Create and use dataflows in the Power Platform
• Dataflow licenses
• Dataflow best practices

Advanced Power Query articles

Concept

• Query folding
• Query diagnostics
• Error handling

Develop your custom connector

How-To Guide

• Custom connector development

Reference content

Reference

• Connectors in Power Query
• M language reference