Power Query
UnknownMicrosoft data transformation and preparation engine with a graphical editor for ETL.
工具信息
什么是 Power Query？
Power Query is a data transformation and data preparation engine that provides a graphical interface for acquiring data from sources and a Power Query editor for applying transformations, enabling extract, transform, and load (ETL) processing of data across products and services.
核心功能
Graphical data acquisition interface
Provides a graphical interface for getting data from sources of all sizes and shapes.
Power Query editor
Primary data preparation experience with a user-friendly set of ribbons, menus, buttons, and interactive components for previewing data and selecting transformations.
Wide data source connectivity
Enables connectivity to hundreds of data sources with consistent experience and parity of query capabilities over all sources.
Hundreds of data transformations
Supports over 350 different types of data transformations that are common across all data sources, applied by interacting with the UI.
Automatic M code generation
Automatically creates the M code required for each transformation step so users do not need to write any code.
Repeatable queries with refresh
Defines a repeatable process (query) that can be easily refreshed manually, via scheduled refresh in specific products, or programmatically to get up-to-date data.
Power Query M formula language
Underlying language used for transformations, with the editor generating M code automatically.
Dataflows support
Supports dataflows as part of Power Query experiences for data preparation.
使用场景
- #1
Data acquisition and connectivity
Finding and connecting to a wide range of data sources while providing a consistent experience across sources of any size and shape.
- #2
Data reshaping and preparation
Rapidly and iteratively building queries to reshape data before consumption using an interactive and intuitive experience.
- #3
ETL processing
Performing extract, transform, and load (ETL) processing of data with destinations that depend on the product or service using the engine.
- #4
Handling data volume, velocity, and variety
Working against a subset of the entire data set to define transformations, filter to manageable size, and refresh queries for up-to-date data from hundreds of sources.
定价方案
No pricing information provided in the official source snapshot; Power Query is an engine included in various Microsoft products and services.
