Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Using Copy Activity from Fabric to fetch on-prem data (SQL Server or SFTP) and land in Lakehouse, do I need a data gateway or Self Hosted Integration Runtime
Solved! Go to Solution.
SHIR is a concept in Azure data factory but in Fabric Data pipelines you need to use Data gateway
Hi @ankushnayy ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you @NandanHegde for the prompt response.
Thank you!
Thank you Nandan.
SHIR is a concept in Azure data factory but in Fabric Data pipelines you need to use Data gateway