Power Query

Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. This engine is available in several products and services from Microsoft, e.g. Excel, Azure Data Factory, Power BI, Power Platform Dataflows