Forum Discussion
SDS - Sync & import of new data fails
Hi together,
we use School Data Sync version 2.1 with a configured flow for automatic import of the current CSV files runs normally without any visible errors, but the data from the CSV files is not imported from the local server.
I created the flow from “Automate CSV upload for task data synchronization.” In the flow, I was also able to open and select the local file system via the data gateway, so there is a connection to the server. The problem is that the files are not being imported.
Can anyone help with this error?
THX
Nik
1 Reply
- Check the gateway service account permissions on the local folder (not just your user). It needs explicit read access.
- Look at the SDS Processing History in the admin portal—the real error is usually hiding there, not in Power Automate.
- 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.
