Network issue via proxy server using On-premises data gateway

[trev_likes_PBI]

I have setup an On-premises data gateway. The path to the Internet is via a proxy server. I am getting an error message stating Network Connectivity is limited when I log on. Clicking on show configurations displays the message

"Ensure network access is functioning correctly. Firewall and proxy configurations may need to be changed."

I have tried the following;

1. The user account works successfully on a PC which has no network restrictions (laptop using 4G hotspot)
2. Updating the enterprisegatewayconfigurator.exe.config file with proxy information
3. Updating the Microsoft.PowerBI.EnterpriseGateway.exe.config file with proxy information
4. Updating the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file to force traffic via HTTP or HTTPS ports only

The following logfile has been taken after rolling back the above configs Logfile

Have you got any ideas on how to solve this?

[v-qiuyu-msft · Accepted solution]

Hi @trev_likes_PBI,

From the error message, the issue is related to Firewall or Proxy. In your scenario, please make sure proxy settings are set correctly.

1. Check which proxy server used in your network.

2. Check which form of authentication used by your proxy server.

3. If your proxy server use windows authentication, please change data gateway service account to a domain user.

For detail information, see: Configuring proxy settings for the On-premises Data Gateway.

Also please use following command to test network connectivity:

Test-NetConnection -ComputerName watchdog.servicebus.windows.net -Port 9350

If firewall blocks the connections that the Azure Service Bus makes to the Azure data centers. Please whitelist (unblock) the IP addresses for your region for those data centers.

If issue persists, please use Fiddler to monitors HTTP traffic. Share us trace file if possible.

Reference:
Troubleshooting the On-Premises Data Gateway

Best Regards,
Qiuyun Yu

[trev_likes_PBI]

In addition, we had to force traffic via HTTPS as well by editing a config file (this should be a last resort due to performance issues). More info below;

Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file. Change the value from AutoDetect to Https.

This file is located, by default, at C:\Program Files\On-premises data gateway.

<setting name="ServiceBusSystemConnectivityModeString" serializeAs="String">

    <value>Https</value>

</setting>