Gateway Setup - need it's own server?

Hi Anonymous ,

You can refer to https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#requirements  for requirements and recommended resources

>>Does it need it's own server? 

No, you can just install it on the server that can connect to your on-premise data source. Based on my experience, you'd better install it on the same server that hold the data source.

>>Is it needed only for on-prem data connections, or do cloud connections go through the gateway as well?

No, it's  not necessary. Only if you contain on-premise data source and cloud data source in one dataset, and you have query to combine these two data source, the cloud data source need to use gateway as well. You can configure it in settings of gateway in power bi service. 

For more details , please refer to https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#accessing-on-premises-and-cloud-sources-in-the-same-source-query

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai