MetricSign
EN|NLRequest Access
Medium severitydata source

Power BI Refresh Error:
DF-SAPODATA-ODataServiceMissed

What does this error mean?

The OData service URL or service path in the SAP OData linked service is blank or missing.

Common causes

  • 1The linked service 'URL' field was left empty when creating the SAP OData linked service
  • 2The service URL was deleted or cleared after an accidental edit
  • 3The linked service was created from a template that uses a pipeline parameter for the URL, but the parameter was not set
  • 4The SAP OData service path changed (e.g., SAP upgrade or namespace change) and the linked service was not updated

How to fix it

  1. 1In ADF Studio, go to Manage > Linked services and open the SAP OData linked service.
  2. 2Enter the full SAP OData service URL in the 'URL' field (format: https://host:port/sap/opu/odata/sap/SERVICENAME/).
  3. 3Test connection confirm ADF can reach the SAP OData service.
  4. 4If using a pipeline parameter for the URL, verify the parameter has a non-null default value.
  5. 5Re-publish the linked service and the data flow pipeline, then trigger a new run.

Frequently asked questions

What does a correct SAP OData service URL look like?

The format is: https://[SAP-host]:[port]/sap/opu/odata/sap/[SERVICENAME]/ — for example https://sap.company.com:443/sap/opu/odata/sap/ZBPORDERS_SRV/. The trailing slash is required. Your SAP BASIS team can provide the correct service path.

Where do I find the SAP OData service name?

In the SAP system, transaction /IWFND/MAINT_SERVICE (SAP Gateway) lists all activated OData services. The service name in ADF corresponds to the 'Technical Service Name' in the SAP Gateway catalog.

Does this error appear if the service URL is wrong vs. missing?

A missing URL triggers ODataServiceMissed. A wrong URL (mistyped, wrong port, wrong namespace) triggers a connectivity error or authentication failure rather than this specific error code — the SAP server needs to be reachable first.

Can I use a parameter for the SAP OData service URL?

Yes — parameterize the URL in the linked service. Ensure the parameter has a non-null default value; if it resolves to null at runtime, ADF still raises this error.

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

Other data source errors