Dataflow Gen2 fail to validate destination with on-premise sql database source

Hi qblanchard ,

Here are some of my personal thoughts on your question:

1. I think you can read this official document below, it might help you: 

On-premises data gateway considerations for data destinations in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

2. Also you can read this fabric blog article: 

Data Factory Spotlight: Dataflow Gen2 | Blog su Microsoft Fabric | Microsoft Fabric

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.