Forum Discussion

trev_likes_PBI's avatar
trev_likes_PBI
Regular Visitor
9 years ago
Solved

Network issue via proxy server using On-premises data gateway

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 configu...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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's avatar
    trev_likes_PBI
    Regular Visitor
    9 years ago

    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>