MetricSign
EN|NLRequest Access
Medium severityconfiguration

Power BI Refresh Error:
SkipMissingFileNotSupportedForNonDirectBinaryCopy

What does this error mean?

The "skip missing file" fault tolerance setting is only available for direct binary copy between file-based stores. It cannot be used with format conversions or tabular sources.

Common causes

  • 1Skip missing file not supported for non-direct binary copy
  • 2Integration runtime configuration is incorrect or outdated
  • 3Authentication credentials or permissions are insufficient
  • 4The feature or setting is not supported for the selected connector or copy mode

How to fix it

  1. 1In the copy activity, go to the Settings tab, and disable the 'Skip incompatible rows' or fault tolerance setting for 'Missing file'.
  2. 2To qualify as direct binary copy (where this setting works), both source and sink must be file-based stores and datasets must use Binary format with no schema mappings.
  3. 3For format-converting copies, handle missing files in pipeline logic — add a Get Metadata activity before the copy and an If Condition to skip it when no files are found.
  4. 4If using a wildcard source, verify the wildcard pattern matches at least one file — the 'skip missing' setting does not prevent errors from a source path that matches no files at all.
  5. 5Validate the configuration after removing the incompatible setting and re-run the pipeline.

Frequently asked questions

Does this configuration error affect every pipeline run?

Yes — configuration errors are deterministic. Every run fails until fixed; retrying does not help.

How do I validate an ADF pipeline configuration before running it?

Click 'Validate' in the ADF authoring UI for configuration checks. For data flows, use Debug mode with a small sample to validate expressions and mappings.

Can dynamic content expressions in ADF cause configuration errors at runtime?

Yes — @activity(), @pipeline(), or @dataset() parameters that resolve to null or an unexpected type cause runtime failures even when design-time validation passes.

Do configuration errors appear in the ADF activity output?

Yes — the ADF Monitor activity detail shows the error code and the specific property that is invalid or missing.

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

Other configuration errors