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?