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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Fabric update to learn about new features.