On prem data gateway

Hi aresblade 

To connect the Power BI Service to your on-premises data source using the On-premises Data Gateway in a setup that includes ExpressRoute with private peering, you can follow a slightly adjusted approach. Even though your data source is on-prem, you're planning to install the gateway on an Azure VM, which is a valid and common architecture—especially when the Azure VM is connected to your on-prem network via ExpressRoute. In this setup, the gateway VM acts as a bridge between the Power BI Service (cloud) and your on-prem resources (databases, files, etc.) via the private ExpressRoute path. Here's how it works: the On-premises Data Gateway, once installed on the Azure VM, initiates outbound connections to the Microsoft Azure Service Bus over HTTPS (port 443). It does not require inbound ports to be open, making it firewall-friendly. As long as the Azure VM can reach your on-prem data source through the ExpressRoute private peering (e.g., SQL Server, SAP, etc.), the Power BI Service will be able to send queries through the gateway to fetch data. Just make sure the gateway VM can resolve and access the on-prem IPs/DNS names correctly. Although documentation is sparse for this specific hybrid setup (Azure-hosted gateway + on-prem ExpressRoute access), it follows the same principles as any on-prem installation—just ensure your ExpressRoute configuration allows traffic from the Azure VM subnet to the on-prem network. Register the gateway in Power BI Service, map it to your data source, and configure scheduled refreshes or DirectQuery as needed.