I can feel that. What I practise is, I used to sent back those files initially and ask them to make the changes and keep the format as it was earlier, though it takes time but that's the best practise.
So ideally they should keep the column name and they might leave it blank if there is no data but the column sequence and names should be similar as they were in last file.
Yeah it woun't show you an explanation for the error, but it would just say load failed or something, but if you'll check the same in Power Query you can find the root cause for the same.
Hope it helps.
If I have answered your question or solved your problem, please mark this post as solved.
If you liked my response, please give Kudos