Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

[DataFormat.Error] Archive file cannot be size 0. - Combine Files

Hi,    Can anyone help with this error? I am combining around 240 excel type files from a SharePoint folder, all files have the same amount of columns and the sheet is named Data on every single on...
Need Help
valeram's avatar
valeram
Regular Visitor
4 years ago

Hi! I had the same issue. The problem was a mismatched file in my list (I don't know why, but the content was broken).

So I went up in the steps of PowerQuery to the first "remove other columns" (5th step usually) and detected the broken file, then I opened that file to know which was the problem (I solved it quickly by downloading again the same file with the correct format.

Best regards.

V