Loading data with Microsoft Fabric Dataflows
Fabric Data Factory has another data transformation tool in its arsenal: Dataflow Gen2 . Readers who have worked with Power BI will be familiar with the concept of Dataflows. While there are many similarities between Data Factory Dataflow Gen2 and Power BI Dataflows (they both allow users to ingest, transform, and combine data from various sources to create reusable and scalable data preparation processes), it’s important to note that as of the time of writing, they are not interchangeable.
If you went through previous chapters of this book, you will remember that ADF also has a concept of Dataflows – a tool to perform common data transformations without writing code. In Fabric, Dataflow Gen2 is considered a Data Factory component, but it has a distinctive interface and allows users to leverage Power Query when designing transformations.
We shall use an instance of Dataflow Gen2 to import data from a data...
