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, Common Data Services for Apps & Analytics, and more.

• 

  Power Query Overview

  Learn about Power Query, and how it can help you connect, transform, and use data from many different sources.

• 

  Use Power Query in Power BI Desktop

  Quickly get started using Power Query by seeing it in action in Power BI Desktop.

• 

  Develop your own connector

  You can develop your own custom connector for Power Query, and enable connecting to your data source of choice.

• 

  Common tasks using Power Query

  See how to perform common tasks using Power Query, including connecting, shaping, and modeling data.

• 

  M language reference

  Gain access to the reference content for the M language, used by Power Query.

• 

  Certify your connectors

  Learn about the process required for your connector to become a certified connector for Microsoft Power Query.