High severitydata source
Power BI Refresh Error:
DF-SAPODP-DependencyNotFound
What does this error mean?
A required component for the SAP ODP connector was not found on the Self-Hosted Integration Runtime host. This means the SAP NCo (NetWeaver RFC Connector) library is not installed or the DLL cannot be located, preventing ADF from establishing an RFC connection to SAP.
Common causes
- 1The SAP NCo 3.0 or 3.1 library (sapnco.dll and sapnco_utils.dll) is not installed on the Self-Hosted IR host machine
- 2The NCo DLLs are installed but in a location that is not in the system PATH or registered in the .NET GAC
- 3The installed NCo version (32-bit vs 64-bit) does not match the bitness of the .NET runtime used by the IR
- 4The NCo library was removed or corrupted during a system cleanup or antivirus action
How to fix it
- 1Download the SAP NCo 3.1 library from SAP Service Marketplace (search for 'SAP Connector for .NET 3.1') — get the 64-bit version for a 64-bit IR host.
- 2Install the NCo library on the Self-Hosted IR host machine — the installer registers the DLLs in the GAC automatically.
- 3Alternatively, copy sapnco.dll and sapnco_utils.dll to the ADF Self-Hosted IR installation directory (C:\Program Files\Microsoft Integration Runtime\<version>\Shared\).
- 4Restart the Self-Hosted IR Windows service after installing or copying the DLLs.
- 5Re-run Test connection on the SAP ODP linked service in ADF Studio to confirm the dependency is now found.
- 6If the error persists, check the IR host Event Viewer (Application log) for .NET assembly load errors that identify the missing component.
Frequently asked questions
Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/data-flow-troubleshoot-guide