Data gateway

The on-premises data gateway is a Windows service running inside a customer's network that bridges cloud services (Power BI, Power Automate, Logic Apps, Power Apps) to on-prem data sources (SQL Server, file shares, custom APIs, legacy applications). Outbound-only connection through Azure Service Bus relay — no inbound firewall openings needed. Two modes: standard (multi-user production, with clustering for high availability) and personal (individual maker, less robust). Configured data sources include credentials; cloud services use the gateway as a routed access point. Essential infrastructure for hybrid cloud / on-prem analytics during transitions and for permanently on-premise data sources. Update monthly; cluster for production resilience.