Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
dhorrall
Frequent Visitor

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

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?

 

dhorrall_0-1685044330350.png

 

 

2 ACCEPTED SOLUTIONS
SidJay
Employee
Employee

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.

View solution in original post

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. 

View solution in original post

5 REPLIES 5

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. 

vitaly
Helper III
Helper III

A few related questions, to clarify the level of support for Fabric Warehouse as the destination of Fabric Dataflows Gen2:

 

  1. According to the documentation at https://learn.microsoft.com/en-us/fabric/data-factory/dataflows-gen2-overview, Fabric Lakehouses as explicitly supported, while Fabric Warehouses are not. Is this documentation aspect out of date? If so, can it please be updated?

  2. We are seeing "New Dataflow Gen2" as an option under "Get Data" in a Lakehouse for all users. We are only seeing it as an option for Warehouse for some users, while others do not see it. What's driving selective availability of this option? Is a feature update currently rolling out in phases?

  3. What are the consequences of using the "Azure Synapse Analytics (SQL DW)" connector to write to a Fabric Warehouse? Given that the Synapse Dedicated SQL pool engine (i.e. "SQL DW") is different from the Fabric Warehouse engine, does the same connector (under whichever label) now support both engines?

 

Thank you!

SidJay
Employee
Employee

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
Community Admin
Community Admin

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Hack Slide Banner

Hack Together: The Microsoft Fabric AI Global Hack

Learn from experts, get hands-on experience, and win awesome prizes.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.