What causes DF-Excel-InvalidRange?

A named range is specified in the dataset configuration but that name does not exist in the current Excel workbook. A cell range (e.g. 'A1:D100') was specified but the workbook has fewer rows or columns than expected. The named range existed in a previous version of the workbook but was renamed or deleted in a newer version

How do I fix DF-Excel-InvalidRange?

Open the Excel source dataset in ADF Studio and check the 'Range' field — if a named range or cell address is configured, note its exact value.. Open the Excel file in Excel and check whether the named range exists: go to Formulas > Name Manager.. If the named range was deleted or renamed in the workbook, update the ADF dataset to use the current range name or the correct cell address.. If the range is a cell address, verify it is within the actual data bounds of the worksheet — the range must not extend beyond the last row of data.. Enable Debug mode and run a data preview to confirm the range resolves correctly.

Medium severitydata flow

Power BI Refresh Error:
DF-Excel-InvalidRange

What does this error mean?

A named range or cell range configured in the ADF Excel source dataset is invalid — either because the range name doesn't exist in the workbook, the cell address is out of bounds, or the range format is incorrect.

Common causes

1A named range is specified in the dataset configuration but that name does not exist in the current Excel workbook
2A cell range (e.g. 'A1:D100') was specified but the workbook has fewer rows or columns than expected
3The named range existed in a previous version of the workbook but was renamed or deleted in a newer version

How to fix it

1Open the Excel source dataset in ADF Studio and check the 'Range' field — if a named range or cell address is configured, note its exact value.
2Open the Excel file in Excel and check whether the named range exists: go to Formulas > Name Manager.
3If the named range was deleted or renamed in the workbook, update the ADF dataset to use the current range name or the correct cell address.
4If the range is a cell address, verify it is within the actual data bounds of the worksheet — the range must not extend beyond the last row of data.
5Enable Debug mode and run a data preview to confirm the range resolves correctly.

Frequently asked questions

Does ADF require a named range, or can I use a cell address like A1:D100?

Both are supported — specify a named range, a worksheet and cell range, or leave the range empty to read the entire worksheet. The error occurs when the specified value doesn't match what's in the file.

Where do I configure the range in ADF?

In the Excel dataset, open the 'Connection' tab. The 'Sheet' and 'Range' fields control which worksheet and cell range ADF reads.

Why did this work before but fail now?

Most commonly the source Excel file was replaced with a version where a named range was renamed, deleted, or the sheet structure changed. Compare old and new files to identify what changed.

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