Why Power Query as an Activity in Azure Data Factory and SSIS?

This article will describe how the Power Query activity in Azure Data Factory (ADF) and Integration Services (SSIS) can be useful. In addition to that, I will share the differences of the Power Query activity between SSIS and ADF.

Why Power Query and When to Use It?

By using Microsoft’s cloud-based ETL tool, Azure Data Factory (ADF) you can build a pipeline to extract, transform and load data from a source to a target. ADF has many activities available, like the lookup activity, merge activity, data conversion activity, in addition to the Mapping data flow activity and the Databricks Notebook