MetricSign
EN|NLRequest Access
Medium severitydata source

Power BI Refresh Error:
DF-SAPODP-ObjectNameMissed

What does this error mean?

The ODP Object field in the ADF dataset is blank. ADF needs an ODP object name to know which SAP extractor, CDS view, or BW DataSource to query. Without it the pipeline cannot start data extraction.

Common causes

  • 1The ODP Object field was left blank when the dataset was created or copied from a template
  • 2A pipeline was imported via ARM template and the object name parameter was not substituted
  • 3A dataset was duplicated from another connector type and the ODP-specific Object field was not filled in
  • 4The dataset is driven by a parameter expression that evaluates to an empty string at runtime

How to fix it

  1. 1In ADF Studio, open the dataset linked to the failing SAP ODP source.
  2. 2Check the ODP Object field — if it is blank, click Browse to connect to SAP and select the correct object from the list.
  3. 3If the dataset uses a parameter for the object name (e.g. @dataset().odp_object), open the data flow or pipeline that calls it and verify the parameter value is being passed and is not empty.
  4. 4If the dataset was created from an ARM template, check the template parameter file for the ODP object name parameter and ensure it is populated.
  5. 5Save the dataset, re-test the pipeline to confirm the error is resolved.

Frequently asked questions

How do I find the correct ODP object name to enter?

Click Browse next to the ODP Object field in the ADF dataset editor. ADF connects to SAP and returns available objects grouped by context. Select the correct one and ADF fills in the name automatically.

Can a parameter expression cause ObjectNameMissed?

Yes — if the dataset uses a dynamic expression like @dataset().objectName and the pipeline doesn't pass the parameter, it evaluates to empty. Check pipeline parameter assignments and set a default in the dataset definition.

What is the difference between ObjectNameMissed and ObjectInvalid?

ObjectNameMissed means the field is completely blank. ObjectInvalid means a name is present but the referenced object is not active or not ODP-exposed in SAP. ObjectNameMissed is resolved in ADF; ObjectInvalid requires SAP-side work.

Can Test connection pass even with the object name missing?

Yes — Test connection validates credentials and network reach but does not validate the dataset-level object name. The missing name is only detected when the pipeline attempts to execute.

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

Other data source errors