Azure Data Factory by Example: Practical Implementation for Data Engineers

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024

R. SwinbankAzure Data Factory by Examplehttps://doi.org/10.1007/979-8-8688-0218-8_9

9. Power Query in ADF

Richard Swinbank¹  

(1)

Tewkesbury, UK

 

ADF data flows, covered in Chapter 7, model a data integration process as a stream of data rows that undergoes a succession of transformations to produce an output dataset. This approach to conceptualizing ETL operations is long established and may be familiar from other tools, including SQL Server Integration Services. While powerful, this view of a process can be inconvenient – for example, for users new to data engineering practices, or when a new, unknown source dataset is being evaluated and understood.

Power Query ...