Medium severityinfrastructure

Power BI Refresh Error:
DataConsistencyValidationNotSupportedForLowVersionSelfHostedIntegrationRuntime

What does this error mean?

The self-hosted integration runtime version installed on the host machine is too old to support data consistency validation. Upgrade the self-hosted IR to the latest version.

Common causes

1Data consistency validation requires a newer self-hosted IR version
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

1In the Azure portal, go to ADF > Manage > Integration Runtimes, check the SHIR version, and upgrade by downloading the latest installer from the Integration Runtime page.
2Data consistency validation requires SHIR version 3.14 or later — check the current version in the IR node status and compare it to the minimum version required in the ADF documentation.
3If upgrading the SHIR is not immediately possible, disable 'Enable data consistency validation' in the copy activity Settings tab as a short-term workaround.
4Plan a SHIR upgrade during a maintenance window — the upgrade restarts the IR service and causes a brief interruption to pipelines using that IR.
5After upgrading, verify the IR status shows the new version in the ADF Management Hub and test the connection before re-running the pipeline with validation enabled.

Frequently asked questions

Does a JRE or JVM error affect all pipelines or only specific connectors?

JVM errors affect only pipelines processing Parquet, ORC, or Avro on a self-hosted integration runtime. Pipelines using other connectors on the same SHIR are not affected.

Why does ADF require a JRE for some file formats?

Parquet, ORC, and Avro use Java-based codec libraries. On a self-hosted IR, ADF invokes a JVM on the host for codec operations. Azure IR includes the JVM; self-hosted IRs require it to be installed separately.

After installing or updating the JRE, do I need to restart anything?

Yes — restart the Microsoft Integration Runtime service on the SHIR host after any JRE or _JAVA_OPTIONS changes. The JVM loads at IR startup and changes don't take effect until the service restarts.

Can custom plugins on the SHIR cause pipeline failures?

Yes — if FailedToDownloadCustomPlugins appears, the SHIR can't download a required plugin. Verify the host has outbound internet access to the ADF plugin endpoint and that no proxy blocks the download.

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