Enterprise Gateway with External Datawarehouse

Hi , Solle 

Depending on your current data source structure: My Computer --> External Firewall --> SQL Login --> SQL Access (AWS) I think whether you configure your Enterprise Gateway installation on a server or on an internal computer, you need to ensure that two things must be done, at least to ensure the success of data refresh, and then to consider the performance aspect:

1. You need to ensure that the server configured in Enterprise Gateway and your SQL Server data source under firewall protection can successfully establish a connection using SQL Login, and you can use the nslookup command to manually test the connection connectivity:
nslookup | Microsoft Learn

Or use UDL tests to perform relevant connectivity tests.

2.Another point is that you need to ensure that Enterprise Gateway is fully connected to Azure service bus in the current server network environment, because Azure service bus is the channel for Enterprise Gateway to communicate data with the external network (PBI service), and you can do a port test on the Enterprise Gateway application:
Adjust communication settings for the on-premises data gateway | Microsoft Learn

After ensuring the smooth connection of these two points, you can start to test whether the connection between the data source and the gateway is normally configured, and if successful, we can then optimize the performance of the gateway, hardware configuration, and performance, you can refer to this document:
Monitor and optimize on-premises data gateway performance | Microsoft Learn

For the detailed introduction and description of the gateway architecture I mentioned earlier, you can refer to this official document, which contains a detailed architecture diagram introduction:

On-premises data gateway architecture | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly