Forum Discussion
Data Flow Gen 2 : Data Destination = Warehouse connection error
I get this error after selecting Data Destination = warehouse in Data Flow Gen2 -
An exception occurred: The given data source kind is not supported. Data source kind: Warehouse.
When I read in data from the Warehouse in my Fabric workspace, I get no error when choosing Data Destination = warehouse.
When I read in data from my Synapse Data Warehouse, or my SQL Server database, I get the error above - data source kind not supported.
What am i missing, and what should I do differently to make this work ok.
aathmer : Thanks for writing back , if I were you i could have accepted NandanHegde response as a solution , that way we could consider this thread to be closed .
Good luck .
7 Replies
Hey,
Can you please specify whether the warehouse that you are trying to map to the destination is a fabric warehouse and not a synpase workspace database?
And are your dataflow gen 2 and fabric warehouse in same workspace?Thanks for replying Nandan - the warehouse I'm trying to map to the destination is a SQL Server database in our Azure environment (previously on-prem).
The warehouse is local to the fabric workspace that also contains the Gen2 DataFlow. The error occurs when the connection is being validated - in the bottom left it says - creating connection - validating connection and then the error message occurs.
Hope this helps - something to do with connecting that is different when the input data is from SQL Synapse not Fabric warehouse.
Hey, unfortunately as of now Dataflow Gen 2 only supports 4 destinations and the databases supported are only:
1) Azure SQL Database
2) Actaul fabric warehouse
SQL Server databases on IaaS is not supported
Thank you Nandan - I'm ingesting data into the Dataflow Gen 2 from the SQL Server - and that works fine.
Then when I select warehouse from the destination options, it fails with the error message above.
When I ingest data from the warehouse inside the Fabric workspace and select warehouse as destination, it works fine - I can copy data into a new table that way.
I'm selecting warehouse as destination - and then get the error. Thank you for help on this Nandan - I cannot figure out what i need to do next.
Hello aathmer ,
Just trying to reinterate the point which NandanHegde calledout before . At this time the below destination are supported by DF Gen2 and since the destination SQL Server database in our Azure environment (previously on-prem) is still not supported so you are getting the error .
Please add this is as a feature ask for the Product team here : https://ideas.fabric.microsoft.com/?view=new
Thanks
HimanshuYes thank you Himanshu I will add to the feature request although I have no current need to write out to SQL Server using Dataflow Gen2.
The Azure / Fabric admin has also updated the Azure Gateway and as a result the error has gone away and I now get prompted for the Fabric warehouse to use as destination. It then fails again with an error that I now know indicates that the firewall on my SQL Server is too restrictive - which the Azure / Fabric admin will address.
So I think in the next week or so I will be able to successfully read from SQL Server and write to the Fabric warehouse using Dataflow Gen2 - which is my goal.
Thanks again for your help.
aathmer : Thanks for writing back , if I were you i could have accepted NandanHegde response as a solution , that way we could consider this thread to be closed .
Good luck .
