An On-premises Data Gateway is a bridge that provides data transfer between on-premises data sources and cloud services like Power BI, Power Apps and Power Automate. It enables organisations to retain their data on-premises while still benefitting from cloud-based applications and services. Various data sources are supported, including SQL Server, SharePoint, and file systems.