Forum Discussion
Fabric - issue adding destination in dataflow
I created a simple Dataflow Gen2 extracting data from a table. I now want to load this data into Fabric warehouse (which I also created). However I am get the following error: "An exception occurred:...
The source is an ODBC connection which gets data throug a gateway. That part works fine, I am getting the data. But when I click Add data destination and trying to configure it to be Fabric warehouse, I am getting the above error after selection Warehouse as destination. "Data source" in the error message is probably missleading, it refers to data target, not the source.
The same scenario with the same source and a warehouse as target worked in a different tenant. I could not figure out the difference.
abpgupta
Continued Contributor
Continued ContributorYes, that was my understanding that we don't need to create or use gateway for cloud resources. For me, we had to create a connection for Lakehouse ODBC and use it to resolve the issue. You can try and see if it works for you as well.