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