Forum Discussion
400 Error When Using On-Premises Data Gateway with Fabric Pipelines (SQL Server Source)
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
Hi v-lgarikapat,
Thank you for the follow-up.
We haven’t yet been able to resolve the issue. We're currently in the process of making changes to the subscription associated with the Fabric instance, which are required to submit the support ticket. Our goal is to have the ticket created by tomorrow.
As soon as we receive any insights or updates from the Microsoft Support team regarding the root cause, we’ll share the details here in the thread.
Thanks again for your continued support.
Best regards,
Marcos
Thanks for the update.
We understand and appreciate you working on it. Looking forward to hearing back once you get more information from Microsoft.
Best Regards,
Lakshmi Narayana