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 . 

NandanHegde's avatar
NandanHegde
Super User
2 years ago

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?

  • 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