Forum Discussion

schneiw's avatar
schneiw
Advocate IV
1 year ago
Solved

Data Pipeline connection error

Hi   I have a managed connection that is using the on prem data gateway. If i test it from the Manage Connections screen in Fabric it gives no error. I used it in a Gen 2 dataflow, no problem.    ...
data engineering
Data Pipeline
  • yvaubourg's avatar
    yvaubourg
    1 year ago

    Hi,

    In my experience, copy data in pipelines with data gateway don't work with all sources enven if it work with Dataflows. Wich Data Source do you have?

     

    Somenone here say that updating your gateway to the latest version can work.

Srisakthi's avatar
Srisakthi
Super User
1 year ago

Hi schneiw 

 

As yvaubourg  mentioned not all the sources supported by dataflow gen 2 is supported in data pipeline.

Here you can find the list of connectors(on-prem) supported in data pipeline

https://learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data

 

Also you have to make some changes for data pipeline to work like network settings

You need to configure the firewall to allow outbound connections *.frontend.clouddatahub.net from the gateway for Fabric pipeline capabilities.

 

Note : Local access to the machine with the on-premises data gateway installed is not allowed in data pipelines.

 

Regards,

Srisakthi

 

If this answer solves your question, please mark "Accept as Solution.