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 marcos-1992 ,
Just wanted to check if you were able to raise the support ticket we talked about earlier.
If not, could you please do it when you get a chance?
Let me know if you need anything from me.
Best Regards,
Lakshmi Narayana
Hi v-lgarikapat,
Yes, we opened a support ticket last week and supplied the Engineering Support team with all relevant details.
We’re now awaiting Microsoft’s response. I’ll update this thread as soon as we have any new information.
Thanks
Thanks for the update. Appreciate you keeping us in the loop we’ll await further information from your side
Best Regards,
Lakshmi Narayana