MetricSign
EN|NLRequest Access
High severitydata source

Power BI Refresh Error:
DF-SAPODP-SHIROFFLINE

What does this error mean?

The Self-Hosted Integration Runtime (SHIR) required for SAP ODP is offline or unreachable. SAP ODP always requires a Self-Hosted IR — the SAP system is on-premises and inaccessible from the Azure IR. Every run fails until the SHIR is online.

Common causes

  • 1The Windows service for the Self-Hosted IR host stopped or crashed
  • 2The host machine running the Self-Hosted IR was rebooted or patched and the IR service did not restart automatically
  • 3Network connectivity between the IR host and the Azure Data Factory service endpoint was blocked (firewall, proxy, VPN)
  • 4The IR host is offline due to scheduled maintenance or a hardware failure

How to fix it

  1. 1In ADF Studio, go to Manage > Integration runtimes and check the status of the Self-Hosted IR — it should show 'Running'; if it shows 'Offline', the host is the problem.
  2. 2Log into the Self-Hosted IR host machine and check that the 'Microsoft Integration Runtime' Windows service is running; if it is stopped, start it manually.
  3. 3After starting the service, wait 1–2 minutes and refresh the IR status in ADF Studio.
  4. 4If the service is running but the IR shows offline, check outbound connectivity from the IR host to *.servicebus.windows.net on port 443.
  5. 5Check whether a recent Windows update or firewall policy change blocked the outbound connection and restore connectivity.
  6. 6To prevent this from recurring, configure the IR service to restart automatically after failure via Windows Service Recovery settings.

Frequently asked questions

Can I use the Azure IR instead of a Self-Hosted IR for SAP ODP?

No — SAP systems are on-premises or in a private network, inaccessible from the Azure cloud. SAP ODP always requires a Self-Hosted IR on a machine with network access to the SAP application server.

How do I make the SHIR service restart automatically after a machine reboot?

Open the Windows Services management console (services.msc) on the IR host, find 'Microsoft Integration Runtime', right-click > Properties > Recovery tab, and set 'First failure', 'Second failure', and 'Subsequent failures' to 'Restart the Service'.

What ports does the Self-Hosted IR need open?

The SHIR needs outbound HTTPS (443) to *.servicebus.windows.net and *.frontend.clouddatahub.net, plus access to SAP on the RFC port (33XX where XX is the instance number). Check with your network team if any are blocked.

Are all pipelines on this SHIR affected or the SAP ODP ones?

All pipelines using this SHIR are affected — SQL Server, Oracle, file shares, SAP, and any other on-premises sources routed through it. Multiple unrelated pipelines failing simultaneously indicates a SHIR outage.

Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/data-flow-troubleshoot-guide

Other data source errors