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.

schneiw's avatar
schneiw
Advocate IV
1 year ago

Thanks for the replies. My connection was a simple on prem SQL Server database. It turns out my DEV gateway was a higher version (latest) than what was on TEST and PROD. My DEV environment worked, but TEST and PROD did not. After I upgraded the TEST gateway it worked. I will do the same on PROD, but we have a strict release process so I can only do that next week, but based on TT enviroment, the upgrade to gateway will fic the issue. Thanks yvaubourg for the recommendation to try the verion upgrade.