SDS - Sync & import of new data fails

1. Check the gateway service account permissions on the local folder (not just your user). It needs explicit read access.
2. Look at the SDS Processing History in the admin portal—the real error is usually hiding there, not in Power Automate.
3. Double-check your CSV encoding – must be UTF-8 (without BOM). SDS fails silently if it’s ANSI or UTF-8-BOM.

Try a quick test: make a simple flow that just reads one CSV file and outputs the content with a Compose step. If that works, the issue is in SDS. If it fails, it’s a path or permission problem on-prem.

Hope that narrows it down. Let us know what you find in the processing history.