Power Query
Power Query is a data transformation and data preparation engine.
Power Query is a data transformation and data preparation engine.
Power Query enables connection to one or many data sources, shaping and transforming data to meet specific needs, then loading the model into tools like Power BI Desktop or Excel. It addresses reshaping data before consumption through a graphical interface for getting data from sources and building repeatable queries. Shaping occurs interactively and iteratively over any data source or size, with automatic generation of M code for transformations. Repeatable processes refresh easily for up-to-date data, handling volume, velocity, and variety by working on data subsets. Available as Power Query Online in dataflows or Power Query for Desktop in Excel and Power BI Desktop.
Power Query uses a visual editor where users apply transformation steps such as filtering, merging, pivoting, and data type changes. These steps are recorded as reusable queries that can refresh automatically when source data updates.
Powerful data cleaning and transformation without coding
Seamless integration with Excel and Power BI
Saves time on repetitive data preparation tasks
Automatic M code generation for transformations
Debugging complex transformations can be challenging
Primarily tied to the Microsoft ecosystem
Discover the future of AI integration with our comprehensive suite of tools and services for developers, businesses, and AI enthusiasts
