MetricSign
EN|NLRequest Access
Medium severitydata flow

Power BI Refresh Error:
DF-Excel-WorksheetNotExist

What does this error mean?

The worksheet name configured in the ADF Excel dataset does not exist in the current Excel workbook. The data flow can open the file but cannot find the specified sheet to read from.

Common causes

  • 1The worksheet was renamed in the Excel file after the ADF dataset was configured
  • 2The pipeline processes multiple Excel files but a new file doesn't contain the sheet that the older files had
  • 3The sheet name in the dataset has a typo, extra space, or capitalization difference from the actual sheet name

How to fix it

  1. 1Open the Excel source dataset in ADF Studio and note the sheet name configured in the 'Connection' tab.
  2. 2Open the Excel workbook and verify the exact sheet names — compare them character by character with the dataset configuration.
  3. 3If the sheet was renamed, update the ADF dataset to use the new name, or rename the sheet in the workbook back to the expected name.
  4. 4If the pipeline processes multiple files, check all files in the source location to confirm each has the expected sheet.
  5. 5Run a Debug data preview after correcting the sheet name to verify the fix.

Frequently asked questions

How do I make the pipeline resilient to sheet name changes?

Use a dataset parameter for the sheet name and pass it from the pipeline trigger or a configuration table — change the sheet name without modifying the dataset configuration.

Can this error occur even when the file path is correct?

Yes — WorksheetNotExist means ADF opened the file but cannot find the sheet. The file path and credentials are not the issue; only the sheet name is wrong.

Are sheet names case-sensitive in ADF?

Yes — 'Sales Data' and 'sales data' are treated as different sheet names. Verify exact capitalization in the Excel workbook.

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

Other data flow errors