Forum Discussion

marcos-1992's avatar
marcos-1992
Regular Visitor
1 year ago
Solved

400 Error When Using On-Premises Data Gateway with Fabric Pipelines (SQL Server Source)

Hello everyone, We are encountering a persistent issue when trying to connect a Fabric Data Factory pipeline to an on-premises SQL Server database using the On-Premises Data Gateway. The same connec...
data engineering
data pipeline
  • marcos-1992's avatar
    marcos-1992
    1 year ago

    Hi everyone,

    We were finally able to identify the root cause of the issue and resolve it, with the support of the Microsoft team, after submitting a support ticket.

    After several troubleshooting sessions and reviewing backend logs from the On-Premises Data Gateway, the Microsoft team discovered that, despite updating the Gateway to the latest version, the Fabric pipeline capability was not properly activated on the gateway instance.

     

    To resolve this, we had to uninstall and then reinstall the On-Premises Data Gateway.
    We used the recovery key available to restore and remap the existing connections during the reinstallation process.

    Once we reinstalled the gateway and confirmed the Fabric pipeline capability was correctly registered, the connection through the Fabric pipeline started working as expected.

     

    I hope this helps anyone who might face a similar issue.

     

    Thanks to everyone who supported this thread!

    Marcos

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

Hi marcos-1992 ,

Thanks for reaching out to the Microsoft fabric community forum.

 

I have included the learning documents for your reference; they may help you

 

Configure SQL server in a copy activity - Microsoft Fabric | Microsoft Learn

Solved: Re: Status 400 Error when setting up an SQL Gatewa... - Microsoft Fabric Community

How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn

The previously known issue has been fixed.

Known issue - Multiple installations of on-premises data gateway causes pipelines to fail - Microsoft Fabric | Microsoft Learn

 

If you're still facing the same issue,
I suggest raising a support ticket so the support team can assist you in resolving the problem.
Please refer to the link below for instructions on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

 

If this post helped resolve your issue, please consider marking it as the Accepted Solution.
This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana