Medium severityconfiguration
Power BI Refresh Error:
SkipInvalidFileNameNotSupportedForSink
What does this error mean?
The sink connector does not support the fault tolerance option to skip files with invalid names. Remove this setting or use a supported sink connector.
Common causes
- 1Skip invalid filename not supported for this sink
- 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
- 1Disable the 'Skip invalid file names' option in the copy activity Settings tab — the sink connector does not support this setting.
- 2Verify file names being written use only valid characters for the destination file system — invalid names come from dynamic path expressions in the sink dataset.
- 3If the sink file name is derived from source data, sanitize it using a string replace expression to remove invalid characters.
- 4Switch to a file-based sink (Azure Blob Storage, ADLS Gen2) if this setting is required.
- 5Validate the pipeline after removing the incompatible setting.
Frequently asked questions
Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-guide