Forum Discussion

Charley194's avatar
Charley194
Frequent Visitor
2 years ago

Issue with Dataflow Gen2 moving data to Azure SQL

I am trying to move data from a Gen1 dataflow into an Azure DB using a Gen2 flow.  I have got this to work and have moved the data.  I did come against this error and I found dealing with this in a o...
Data Integration
Fundamentals
v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi Charley194 

 

When using Microsoft Fabric Dataflow Gen2 with an on-premises data gateway, you might encounter issues with the dataflow refresh process. The underlying problem occurs when the gateway is unable to connect to the dataflow staging Lakehouse in order to read the data before copying it to the desired data destination. This issue can occur regardless of the type of data destination being used.

For more details please refer Link

This might help you in resolving the issue.

Please do let us know in case if you have any further questions.

 

Thanks.

Charley194's avatar
Charley194
Frequent Visitor
2 years ago

Hi sorry for the late reply.

Sadly the two suggestions have not work.  I have confirmed the gateway and we are on the latest verison.  I have confirm there is nothing on the server where the gateway is located that would block outbound traffic.  Though I dont think this is the issue, as this looks like a data type issue