First published on TECHNET on Dec 14, 2017
The Azure On-premises Data Gateway is designed to facilitate secure communication between cloud resources like PowerApps, Flow, PowerBi and Azure Analysis and your on-prem resources like SQL, Files, or SharePoint. The gateway has several requirements
On-prem server to install the gateway to
Azure Gateway Cloud Service and Azure Service Bus
Opening the following Outbound ports 443, 5671, 5672,9350 – 9354
The Azure gateway should be in the same location as the Azure Resource that is using it, which in turn they should be in the same general area as your on-prem gateway and data source, for more details see this
You can follow this
to install and configure the gateway on your network.
The gateway is for connecting cloud resources (Power BI, Azure Analysis Service, etc) to on-prem resources and not the other way around.
Gateway can connect to many resources in your enterprise and does not require that those resources be on the same server as it. However for best performance it is recommended that the gateway and sources be in the same datacenter
Credentials are stored in cloud, but decrypted only once they reach on-prem
Recommend good network throughput like that provided by ExpressRoute
Number of users that consume a report that uses a gateway does matter, size your hardware appropriately