High severitygateway
Power BI Refresh Error:
InputValidationError
What does this error mean?
Fabric Mirroring cannot reach the on-premises data gateway (OPDG) endpoint. The error code InputValidationError appears alongside 'Gateway is unreachable' and indicates a gateway connectivity problem, not a data validation issue despite the name.
Common causes
- 1The on-premises data gateway service is stopped or not running on the gateway machine
- 2Network connectivity between Fabric and the gateway endpoint is blocked (firewall, proxy, or VPN)
- 3The gateway was registered under a different tenant or user account than the one used for mirroring
- 4The gateway machine's outbound internet access to Azure Service Bus is restricted
- 5Gateway version is outdated and no longer supported by the Fabric service
How to fix it
- 1Follow the full on-premises gateway troubleshooting guide: https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot
Beyond the docs
Common practitioner solutions not covered in the official documentation.
- 1Open the On-premises Data Gateway app on the gateway machine and verify the service is running and showing 'Online'
- 2Check that the gateway machine can reach the required Azure Service Bus endpoints (*.servicebus.windows.net on port 443 or 5671)
- 3Review the gateway diagnostic logs for specific connection errors (available in the Gateway app under Diagnostics)
- 4Ensure the gateway is registered under the same tenant as the Fabric workspace used for mirroring
- 5Update the gateway to the latest version if it is outdated
Official documentation: https://learn.microsoft.com/en-us/fabric/mirroring/sql-server-troubleshoot