What causes DF-SAPODP-KeyColumnsNotSpecified?

Delta extraction is configured but the dataset schema was imported without selecting key column markers. The ODP object's key fields were not mapped when the dataset schema was set up. The SAP extractor does not have primary key fields defined and the ODP framework cannot infer them automatically

How do I fix DF-SAPODP-KeyColumnsNotSpecified?

In ADF Studio, open the SAP ODP dataset and click Import schema to reload the field list from SAP.. After importing, review the field list for key column indicators — some ODP objects mark key fields automatically; for others you need to manually identify them based on the SAP table structure.. In the ADF data flow source, check Source options for any key column specification settings and enter the key field names.. Alternatively, consult your SAP team to confirm which fields are the primary key for the ODP object — for a BW DataSource these are the characteristic fields marked as key.. If the extractor truly has no primary key and delta is required, discuss with the SAP team whether the extractor can be enhanced to include a key field.

Medium severitydata source

Power BI Refresh Error:
DF-SAPODP-KeyColumnsNotSpecified

What does this error mean?

The ODP extractor requires key columns for delta extraction, but none are configured in the ADF dataset. Key columns uniquely identify records and allow the ODP framework to track delta changes.

Common causes

1Delta extraction is configured but the dataset schema was imported without selecting key column markers
2The ODP object's key fields were not mapped when the dataset schema was set up
3The SAP extractor does not have primary key fields defined and the ODP framework cannot infer them automatically

How to fix it

1In ADF Studio, open the SAP ODP dataset and click Import schema to reload the field list from SAP.
2After importing, review the field list for key column indicators — some ODP objects mark key fields automatically; for others you need to manually identify them based on the SAP table structure.
3In the ADF data flow source, check Source options for any key column specification settings and enter the key field names.
4Alternatively, consult your SAP team to confirm which fields are the primary key for the ODP object — for a BW DataSource these are the characteristic fields marked as key.
5If the extractor truly has no primary key and delta is required, discuss with the SAP team whether the extractor can be enhanced to include a key field.

Frequently asked questions

How do I identify the key columns for a SAP ODP object?

For BW DataSources, check RSA6 for InfoObjects marked as key characteristics. For ABAP CDS views, look for primary key annotations in SE11. For SAPI extractors, check the SE11 structure — key fields are marked explicitly.

Can I use full extraction mode to avoid this error?

Yes — full extraction reloads everything on each run and does not require key columns. If delta is not strictly required and data volume allows, switching to full extraction is the fastest fix.

Does this error affect only the SAP ODP connector or other connectors too?

This specific error code (KeyColumnsNotSpecified) is specific to the SAP ODP connector. Other connectors have their own key column or upsert key configuration, but they surface different error codes.

Will downstream Power BI datasets be affected?

Yes — the pipeline fails without loading data. Dependent datasets show stale data until the key column configuration is corrected.

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