MetricSign
Start free
High severitygateway

Power BI Refresh Error:
Unable to Connect. Details: "Unknown error in data gateway"

What does this error mean?

A generic gateway error with no inner detail. Usually the gateway service crashed, was stopped, or lost its Azure Service Bus connection.

Common causes

  • 1The gateway Windows service crashed or was stopped
  • 2The gateway lost its connection to the Azure Service Bus relay
  • 3A gateway update was applied and the service needs a restart
  • 4Resource exhaustion on the gateway machine (CPU, memory, disk space)
  • 5Anti-virus or Windows Defender blocked a gateway DLL or network operation

How to fix it

  1. 1Check the gateway logs in %localappdata%\Microsoft\On-premises data gateway for error detail.
  2. 2Check Windows Event Viewer → Application log for crashes in PBIEgwService.

Beyond the docs

Common practitioner solutions not covered in the official documentation.

  1. 1Open Services.msc on the gateway machine and restart the 'On-premises data gateway' service
  2. 2Verify the gateway machine has sufficient disk space (spooling errors can cause this)
  3. 3Temporarily disable real-time anti-virus scanning on the gateway install folder and retry
  4. 4If the error persists, uninstall and reinstall the gateway using the latest installer from Microsoft

Frequently asked questions

Does this error affect all datasets using the same gateway?

Yes — all datasets routed through the affected gateway will fail simultaneously. Resolving the gateway configuration or credential issue restores all of them at once.

Does this error appear in Power BI Desktop?

No — Power BI Desktop connects directly to data sources. Gateway errors only occur when Power BI Service initiates a scheduled or manual refresh.

Can this error resolve itself without intervention?

No — gateway errors require manual action: re-entering credentials, restarting the gateway service, or correcting the network path between the gateway and the data source.

How long does it typically take to fix?

A simple credential refresh takes 5–10 minutes. Network or firewall issues can take 30–120 minutes depending on your infrastructure access.

Source · learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot

Other gateway errors