Solved: Refresh error: Archive file cannot be size 0

Anonymous · ‎08-03-2021

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 · ‎08-04-2021

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,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

ibarrau · ‎08-04-2021

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,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog