What causes SqlParallelFailedToGetPartitionRangeSynapse?

The partition column specified for parallel copy has no rows in the table (empty table). The partition upper and lower bounds were set incorrectly and the range contains no data. ADF lacks the necessary permissions to run the internal partition range query on the Synapse pool

How do I fix SqlParallelFailedToGetPartitionRangeSynapse?

Verify the partition column contains data by running a SELECT MIN, MAX query on the column.. If setting manual bounds, ensure the upper bound is greater than the lower bound and the range covers actual data.. Check that the ADF linked service identity has at least db_datareader permission on the Synapse pool.. Consider using dynamic range mode without manual bounds to let ADF auto-calculate the partition range.

Medium severitydata sourceAzure Data Factory →

ADF Pipeline Error:
SqlParallelFailedToGetPartitionRangeSynapse

What does this error mean?

ADF could not determine the partition range for parallel copy from a Synapse Dedicated SQL pool — the internal partition range query returned no results or failed.

Common causes

1The partition column specified for parallel copy has no rows in the table (empty table)
2The partition upper and lower bounds were set incorrectly and the range contains no data
3ADF lacks the necessary permissions to run the internal partition range query on the Synapse pool

How to fix it

1Verify the partition column contains data by running a SELECT MIN, MAX query on the column.
2If setting manual bounds, ensure the upper bound is greater than the lower bound and the range covers actual data.
3Check that the ADF linked service identity has at least db_datareader permission on the Synapse pool.
4Consider using dynamic range mode without manual bounds to let ADF auto-calculate the partition range.

Frequently asked questions

Does this error affect all pipeline runs or just the current one?

Depends on the root cause. A persistent misconfiguration fails every run; a transient issue may resolve on retry. Check the run history.

Can this error appear in Azure Data Factory and Microsoft Fabric pipelines?

Yes — the same connector errors appear in both ADF and Fabric Data Factory pipelines.

How do I see the full error detail for an ADF pipeline failure?

In ADF Monitor, click the failed run, then the failed activity. The detail pane shows the error code, message, and sub-error codes.

Will downstream Power BI datasets be affected when an ADF pipeline fails?

Yes — a dataset refreshing after the pipeline will use stale data or fail if the target table was cleared. The Power BI refresh may succeed while serving wrong data.

Source · learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-synapse-sql