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.
HI Team, we are migrating ADF pipelines to Fabric Data Factory where as we have On-Premisis sql servers data copying with Integration runtime now we are trying to set up common On-Premisis Gateway to connect multiple sql servers.
looking some help in setting up common gateway.
Solved! Go to Solution.
Hi @MaheshSanga,
You need to install the gateway in the multiple VMs you mentioned, and you would require the recovery key that you had generated when you installed the gateway the first time.
Below is the complete instructions on how to do that:
Hi @MaheshSanga,
Similar to ADF Self-hosted Integration Runtime (SHIR), you have a On-premises Gateway in Fabric through which you would be connecting to the on-prem systems.
In the current VM where you have installed SHIR, you can install On-prem gateway as well and establish connection to it from Power BI Manage connections page. Once you configure the gateway, you can create SQL connections on the Gateway using the same Manage Connections page.
yes I have done it already able to connect SQL Server from gateway but would need help in how to set the same gateway to access multiple sql servers which are from different VM's like centralized Gateway across sql servers.
Hi @MaheshSanga,
You need to install the gateway in the multiple VMs you mentioned, and you would require the recovery key that you had generated when you installed the gateway the first time.
Below is the complete instructions on how to do that:
Hi @MaheshSanga ,
If our response addressed by the @govindarajan_d your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Hi @MaheshSanga ,
If our previous response posted by @govindarajan_d was helpful, please consider clicking "Accept Answer" and selecting "Yes" for whether the answer was helpful. If you have any further questions or need additional assistance, please don't hesitate to reach out.
Thanks for using Microsoft Fabric Community.
Hi @MaheshSanga ,
If our response addressed by the @govindarajan_d your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
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.
User | Count |
---|---|
13 | |
5 | |
4 | |
3 | |
2 |