Forum Discussion

dross's avatar
dross
New Member
3 years ago

Azure Synapse Link periodically reports Operating System Error Code 12

We've recently moved data into Azure Synapse Link. I periodically (every other day or so?) receive errors like this:   Failure details: The last refresh attempt failed because of an internal servic...
Need Help
D_PBI's avatar
D_PBI
Post Partisan
3 years ago

I've recently switched over to using Synapse and am facing the same issue.
Google returns a number of different answers but the one I found that had most legs was due to the failing CSV file being updated at the same time you are trying to read from it.
I decided to test this theory. I refreshed a Power BI report and received a failure the same as yours (obviously with a different file path). I then navigated in Synapse and saw the entity's CSV file had indeed been updated during the time Power BI was refreshing. It confirms the theory.
I find this surprising as it would mean you cannot refresh or build against the source (Synapse) and have any PQ evualtion complete if the end-user are updating the raw source (which get pushes through to Synapse).
I now attempting to understand if our Synapse configuration is correct or does it need further tweaking.

dross's avatar
dross
New Member
3 years ago

I'll be interested to hear if you've had to modify any settings, D_PBI . I too wondered if the error is produced by the file being in use (ie: being written to).