On-Prem Data Gateway

[bao_phan]

Hi folks,

I have a question about data gateway, really appreciate for all your help!!! I have an on-prem SQL Server on Server A, and i will connect to that SQL server from Power BI for reporting then publishing it to Service. Question is, where do i install the standard on-prem gateway since that gateway will also share for other users. 

* Do i install it directly on Server A.

* Or, if I install it on Server B, will I still can connect to Server A using the gateway on Server B.

Thank you everyone for your help.

[v-lgarikapat · Accepted solution]

Hi @bao_phan ,

Thanks for reaching out to the Microsoft fabric community forum.

The best practice for setting up the On-Premises Data Gateway depends on your setup. You can install it on Server A (SQL Server) for lower latency, but this may affect performance if the SQL Server is heavily used. Alternatively, installing the gateway on Server B (a separate machine) works as long as Server B has network access to Server A. This setup helps distribute workloads and ensures that Server A isn’t impacted. For shared use, it's recommended to install the gateway on a dedicated, stable machine with consistent network connectivity to both Power BI Service and SQL Server.

Attached learning documents for your reference; they may be helpful to you

On-premises data gateway - Power BI | Microsoft Learn

Download On-premises data gateway from Official Microsoft Download Center

Install an on-premises data gateway | Microsoft Learn

On-premises data gateway May 2025 release | Microsoft Fabric Blog | Microsoft Fabric

If this post helped resolve your issue, please consider  marking it as the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,

Lakshmi Narayana.