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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

I still could not reproduce your problem until now... Even if there is no data in an excel file, it will not affect the combination and load.

 

Maybe you could try to

1.Enable the Skip files with errors option as shown below

2.Check the Applied Steps in Power Query 

3.Upgrade your Power BI Desktop to the latest version

 

 

Refer to :

https://community.powerbi.com/t5/Desktop/Date-format-error/td-p/130510

https://community.powerbi.com/t5/Desktop/DataSource-Error-Could-not-find-file/td-p/178314

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your response, unfortunately I need all files of data to be included so skipping files with errors will not fix my issue - It still gives me the same error when I try to load to model however skipping would not be a long term solution as I need to ensure every single file and row of data is inclueded so it's more of a case of needing to find where the problem file lies so that I can fix whatever the issue is so that it is included and not skipped.

     

    My Desktop PBI is the most up to date version, and I did check applied steps but nothing gave any indication as to where the problem was occuring.

     

    Thanks again.