Problem to import on premise data onto a lakehouse using a DataflowGen2

Hi alfBI 

Thanks for using Microsoft Fabric Community.

As I understand that you are trying to load data from an on premise SQL Server onto a Fabric lakehouse using a Dataflow Gen2.

In scenarios where your data sources are located on-premises, Microsoft provides the On-Premises Data Gateway to securely bridge the gap between your on-premises environment and the cloud. This document will guide you through the process of accessing on-premises data sources within Data Factory for Microsoft Fabric using the On-Premises Data Gateway.

For more details please refer to the below mentioned links:

Install an on-premises data gateway.

How to access on-premises data sources in Data Factory for Microsoft Fabric.

On-premises data gateway considerations for data destinations in Dataflow Gen2.

I hope this information is helpful. Please do let us know if you have any queries.