Forum Discussion

dhorrall's avatar
dhorrall
Icon for Advocate I rankAdvocate I
3 years ago
Solved

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, ...
Dataflows
  • SidJay's avatar
    SidJay
    3 years ago

    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.

  • miquelladeboer's avatar
    miquelladeboer
    3 years ago

    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. 

miguel's avatar
miguel
Icon for Community Admin rankCommunity Admin
3 years ago

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.

Scott_Powell's avatar
Scott_Powell
Icon for Advocate IV rankAdvocate IV
3 years ago

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