Forum Discussion

bdpr_95's avatar
bdpr_95
Helper IV
5 months ago
Solved

How to Use Dataflows Gen2 Without Creating a Lakehouse in Microsoft Fabric

Hi, I have a use case where I want to create a Dataflow Gen2. However, I don’t want to store it in a Lakehouse, I want to use the same approach I have with Dataflows Gen1, where the purpose is to use...
  • v-hjannapu's avatar
    v-hjannapu
    5 months ago

    Hi bdpr_95 ,
    Thanks for the details.
    Yes, you are correct Since deployment pipelines support only Dataflow Gen2, you will need to go with Gen2 for Dev to Prod movement. But in Gen2, the staging Lakehouse is required and we cannot avoid it at the moment. Even if you only want to use the data in a semantic model, Fabric will still create or use a Lakehouse in the backend. So in your case, the best way is to use Gen2, let it load data into a Lakehouse you can keep it just for staging purpose, and then connect your semantic model to it. As of now, there is no option to achieve Gen1-like behavior without storage in Gen2.

    Hope this helps. Let me know if you need anything else.
    Regards,
    Community Support Team.