Forum Discussion

pepmarti9991's avatar
pepmarti9991
New Member
6 months ago
Solved

OnPremise GateWay error

I have a gateway connection to SQL Server on one server. The server was changed, and the gateway was reinstalled and the Power BI workbooks published. Since then, the gateway has been failing almos...
Warehouse
  • v-sshirivolu's avatar
    v-sshirivolu
    6 months ago

    Hi pepmarti9991 ,
    This issue is usually related to how the On premises data gateway is installed or maintained after an environment change, rather than a Fabric warehouse problem itself. The recommended approach is to first review the gateway diagnostic logs to understand why the gateway is failing, then ensure the gateway is running on the latest version, properly registered, and continuously running without interruptions. Microsoft also advises reinstalling the gateway using the recovery key, validating that the gateway service and data source credentials are still valid, and confirming that outbound network access especially HTTPS and required service-bus ports is not being blocked by firewalls or proxies.
    If the gateway continues to fail even after following these documented steps, Microsoft’s next step is to open a support ticket and share the gateway logs for deeper investigation.

    Refer this doc:
    https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot

v-sshirivolu's avatar
v-sshirivolu
Community Support
6 months ago

Hi pepmarti9991 ,
This issue is usually related to how the On premises data gateway is installed or maintained after an environment change, rather than a Fabric warehouse problem itself. The recommended approach is to first review the gateway diagnostic logs to understand why the gateway is failing, then ensure the gateway is running on the latest version, properly registered, and continuously running without interruptions. Microsoft also advises reinstalling the gateway using the recovery key, validating that the gateway service and data source credentials are still valid, and confirming that outbound network access especially HTTPS and required service-bus ports is not being blocked by firewalls or proxies.
If the gateway continues to fail even after following these documented steps, Microsoft’s next step is to open a support ticket and share the gateway logs for deeper investigation.

Refer this doc:
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support
    6 months ago

    Hi pepmarti9991 ,

    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

     

    • v-sshirivolu's avatar
      v-sshirivolu
      Community Support
      6 months ago

      Hi pepmarti9991 ,
      I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions