Do I have to land DW data into a lakehouse first?

[ScottPowell]

Hi, I'm trying to use Gen2 dataflows to land data into a Data Warehouse. Do I have to land it first into a Lakehouse, and then from there get it into the warehouse?

I'm not seeing the option in a Gen2 dataflow to land it directly to a warehouse, and all of the tutorial vids seem to show it going to lakehouse first.

Thanks,

Scott

[PRADEEPCH-MSFT]

@ScottPowell - Thanks for the question and using MS Fabric community.

When you are using get data with new dataflow gen2 there is an option to add destination  where you can select datawarehouse as the destination as shown below:

For more details, refer to Quickstart: Create your first dataflow to get and transform data.

Hope this helps. Do let us know if you any further queries.

[ScottPowellECU]

hi @PRADEEPCH-MSFT , replying from my work account so I can show what I see. That's actually the first place I checked - but In my tenant I do not get a "Warehouse" option under either the add destination area you show, or if I click on the button in the ribbon. All I see is this (same options also under the add destination at bottom right corner):

Also - the workspace this is does definitely contain a Warehouse, so it's not like the option is missing because I have no warehouses built. See the image below.

Is it possible you're seeing this in a newer version that hasn't been pushed to all tenants yet?

FYI - if it helps in troubleshooting, we are Power BI Premium capacity customers, this workspace is backed by a Premium capacity.

Thanks,

Scott

[PRADEEPCH-MSFT]

@ScottPowellECU - Please do confirm if you are able to see the Microsoft Fabric (Preview) data sources while choose data source option as shown below:

[ScottPowellECU]

Hi @PRADEEPCH-MSFT , if I connect from Power BI desktop I do indeed see the warehouse listed, image below.

Thanks,

Scott

[ScottPowellECU]

Just to follow up on this thread, in another post Microsoft posted that adding the warehouse option will be "coming soon". For now we can use the Azure Synapse Analytics (SQL DW) option.

Thanks,

Scott