March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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?
Solved! Go to 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.
Hi, we are currently rolling out the Fabric warehouse connector for output destinations in dataflow gen 2. With this new connector you can browse you Fabric workspaces and select your warehouse from the navigator experience in the same way as you currently can with the Fabric Lakehouse connector. This capability will come to your region very soon!
In the meantime, you can use the Azure Synapse Analytics (SQL DW) connector to load your data to the Fabric warehouse.
Hi, we are currently rolling out the Fabric warehouse connector for output destinations in dataflow gen 2. With this new connector you can browse you Fabric workspaces and select your warehouse from the navigator experience in the same way as you currently can with the Fabric Lakehouse connector. This capability will come to your region very soon!
In the meantime, you can use the Azure Synapse Analytics (SQL DW) connector to load your data to the Fabric warehouse.
A few related questions, to clarify the level of support for Fabric Warehouse as the destination of Fabric Dataflows Gen2:
Thank you!
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.
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.
Hi, one other thing to please pass along - not only should the name say "Warehouse" instead of "Azure Synapse Analytics (SQL DW)" - when you choose that option, it should also let you find the warehouse by the warehouse name. You shouldn't have to copy and paste in the SQL connection string, the UI should find that for you.
Thanks,
Scott
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!