Hybrid BI architecture connecting on-premises ERP systems (SAP, Dynamics, custom) and SQL databases to cloud-based Power BI via the On-Premises Data Gateway. The gateway acts as a secure bridge, enabling real-time data refresh and connectivity without exposing internal systems to the internet. This pattern solves the challenge of centralizing analytics across legacy enterprise systems while maintaining data residency and security compliance. Fork this diagram on Diagrams.so to customize gateway configurations, add additional data sources, or document your own hybrid BI topology. The gateway supports scheduled refresh, DirectQuery, and import modes depending on latency and data volume requirements.