About This Architecture

Multi-AZ AWS VPC architecture with Power BI gateways deployed on Windows EC2 instances across two availability zones for resilient on-premises data connectivity. Internet Gateway and NAT Gateways enable outbound connectivity from private subnets to Power BI Service, while Windows EC2 instances running Power BI Gateway access MariaDB RDS databases in isolated data subnets. MariaDB RDS instances are configured with standby replicas across AZ-2, and CloudWatch plus Secrets Manager provide monitoring and credential management. This architecture eliminates single points of failure by distributing gateways and databases across availability zones, ensuring continuous Power BI refresh operations even during zone outages. Fork this diagram on Diagrams.so to customize subnet ranges, instance types, or add additional data sources behind the gateway layer.

People also ask

How do I architect a highly available Power BI gateway solution on AWS with MariaDB databases across multiple availability zones?

This diagram shows a production-grade AWS VPC design with Power BI gateways deployed on Windows EC2 instances in private subnets across two availability zones, each with NAT gateways for outbound connectivity to Power BI Service. MariaDB RDS instances in isolated data subnets include standby replicas for automatic failover, while CloudWatch and Secrets Manager provide monitoring and secure credent