Dataflow (Gen2): Fabric Warehouse Destination...this was unexpected!

[dhorrall]

Scenario

I wanted to create a Dataflow that changed some data and load the result to a Fabric Warehouse table.

At first, I thought it would not work directly.  I only see Azure SQL Database, Lakehouse, Azure Data Explorer, and Azure Synapse Analytics as Options.  See attached picture.  I figured perhaps you have to dump the results to Lakehouse and then have a Copy step to load to Fabric Warehouse.

On a whim I tried choosing 'Azure SQL database' and used the Fabric Warehouse connection string, and database name.  And voila...it worked!  I am wondering if it is suppsed to work this way.  Why would 'Warehouse' not be a choice?

[SidJay · Accepted solution]

You can think of the "Azure Synapse Analytics (SQL DW)" entry as "Fabric Warehouse". We will be fixing the UI to address the incorrect naming.

[miguel]

Thank you for the feedback! I went ahead and forwarded this information to the appropriate internal team so they can take a look at this thread.