According to Microsoft, it is recommend to have the data gateway installed as close as possible to the data source to minimize latency. If that is the case, I'm assuming for most people, it means the SQL server. However, I been hearing different voices where installation of the gateway on SQL produciton is not recommended. Anyone knows why this is not recommended? Anything has to do with resources/overhead? the nature of how SQL works? Or firewall/ports issues?
That makes perfect sense! Thank you.
Generally speaking, it is against Microsoft best practice to install anything other than required components on a dedicated system server (SQL, Exchange, SharePoint, etc.).
You can certainly install the connector directly on the SQL Server, but it is an added component that could possbily affect the performance or stability of the server - which is why they do not recommend it. For one of our clients, we installed the Gateway directly on the web front end server within their SharePoint environment without issue. Although I would have preferred to have not done so - but they didn't want to pay for another VM.
Most IT infrastructures have "tools" or "jump" servers within their environments to house small, one-off tools like the Gateway connector which is considered "best practice."
Thank you for your reply, but I'm still not sure why it is not recommended to have the instance installed right on the server itself?
Hi @photonacl ,
I recommend you to install the data gateway on you computer.
Then you can create the connections of 'SQL server' via on-premises data gateway in flow.
As the document says:
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
The On-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and the Power BI, Microsoft Flow, Logic Apps, and PowerApps services.
Best Regards,
Community Support Team _ Zhongys
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.