Forum Discussion
Issue while trying to use an on-premises SQL Server source in Microsoft Fabric pipeline
Hi Rakuka ,
I would take a moment to thank Lodha_Jaydeep , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
Thank you for your follow-up.
I have raised a formal Microsoft support ticket on this issue, and their final response was that the limitation is tied to the tenant/home region, not the individual workspace setting or a local configuration problem. I verified this from About Microsoft Fabric in the tenant settings, and my Fabric home region is West India.
Microsoft confirmed that West India currently does not support the use of an on-premises data gateway for Fabric Data Factory pipelines / Copy activity. They also mentioned that, in this scenario, even if a connection is created successfully, it may still not appear properly under pipeline connections or Copy activity source selection. That matches exactly what I observed during troubleshooting.
So based on the Microsoft ticket outcome, this appears to be a regional product limitation rather than an issue with my SQL Server, gateway, authentication, browser, workspace, or connection setup. I had already validated SQL Server access in SSMS, confirmed port 1433 was working, verified that the gateway was online, and confirmed the gateway network diagnostics passed successfully.
Now I am planning to change the region possibly. Thanks.
Hi Rakuka,
Thank you for confirming.You can verify the hosting region directly within the Workspace Settings, ideally these should align with your capacity settings.
I recommend migrating your workspace to the Central India region, if your organization's policy allows, to ensure full access to the features we discussed. Once you have finalized the new configuration, please let me know if the issue persists or if any further questions arise.
Hi Rakuka ,
I would take a moment to thank Lodha_Jaydeep , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.Thank you Lodha_Jaydeep , tayloramy v-tejrama for all the help from this community.
