Forum Discussion

aathmer's avatar
aathmer
Frequent Visitor
2 years ago
Solved

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...
data warehouse
  • HimanshuS-msft's avatar
    HimanshuS-msft
    2 years ago

    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 . 

aathmer's avatar
aathmer
Frequent Visitor
2 years ago

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.

 

NandanHegde's avatar
NandanHegde
Super User
2 years ago

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