Fabric Dataflow Gen2 Destination Schema

Hi , Dataflow Gen2 does not automatically write to a custom schema in a Warehouse by default. When you pick a Warehouse destination in Dataflow Gen2, it will initially show only the dbo schema and create new tables there unless you explicitly select an existing table in another schema. That’s because the UI doesn’t expose a direct “schema” dropdown in the wizard by default. There is a way to pick a non-dbo schema if you’ve already created the table in that schema ahead of time: Pre-create your destination table in the Bronze (or other) schema. In the Dataflow Gen2 destination settings, change the destination and select the existing table in your desired schema. This will load your data into that schema instead of dbo. Alternatively, some community members noted that an Advanced option (“Navigate using full hierarchy”) sometimes lets you see and pick schemas when selecting your destination, but this can be hard to find and isn’t obvious in the default wizard. So the current behavior is: Default: Gen2 writes to dbo schema unless you select an existing table in another schema. Workaround: Pre-create tables in Bronze/Silver/Gold, then point your Gen2 flow to those existing tables. There isn’t yet a simple schema picker dropdown for new tables in the Gen2 destination wizard. Hope that helps clarify the behavior!