Forum Discussion

iBusinessBI's avatar
iBusinessBI
Kudo Collector
2 years ago

Dataflow vs. Dataflow Gen2 vs. Warehouse

I have the following scenario: 1. Step 1 - I want to connect to Salesforce and get an Opportinities table AS-IS 2. I want to connect to the table from Step 1 and do all kinds of complex transf...
Need Help
aj1973's avatar
aj1973
Community Champion
2 years ago

Hi iBusinessBI 

Dataflow and Dataflow Gen2 are two features of Microsoft Fabric Data Factory that allow you to transform data using a low-code interface and Power Query. Dataflow Gen2 is the newer and improved version of Dataflow, with some key differences:

  • Dataflow Gen2 has a shorter and simpler authoring experience, with auto-save and background publishing features.
  • Dataflow Gen2 supports more data destinations, such as Fabric Lakehouse, Azure Data Explorer, Azure Synapse Analytics, and Azure SQL Database.
  • Dataflow Gen2 has more powerful compute engines and data movement capabilities, enabling high-scale and high-performance data transformations.
  • Dataflow Gen2 supports Direct Query and Incremental Refresh via the Dataflow connector.

Differences between Dataflow Gen1 and Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

  • iBusinessBI's avatar
    iBusinessBI
    Kudo Collector
    2 years ago

    Thanks, Amine. 
    I wanted a solution to my specific scenario. 
    I am pretty much convinced that I am good with Gen1 dataflows, maybe except for "improved compute engine" of Gen2