Refresh error: Archive file cannot be size 0

[Anonymous]

Hi all,

I've suddenly encountered a scheduled refresh error that was working fine for weeks until now. My data is sourced from a Sharepoint folder and it does not seem like I'm pulling any files that are size 0.

Data source error: Archive file cannot be size 0.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

Would appreciate some insights into this please, thank you!

[ibarrau · Accepted solution]

Hi. It sounds like you are reading several files from a folder. Be sure that the files are the same and there was not a modification or addition of a file with size 0. Anyone can just create a blank file by error with 0 size. 

If that's the case. You can delete the file or you might be able to filter that on Power Query as well.

I hope that helps,