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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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