Refresh Error: Refresh failed: Archive file cannot be size 0.

[Anonymous]

I am using the scheduled refresh option in powerbi service to refresh dashboard multiple times in a day. The data sources are excel files present in SharePoint. These datasets are uploaded to sharepoint through another automation script again multiple times a day. So batch script uploads files to SharePoint and then powerbi service refreshes dashboard. I get sporadic refresh failure notifications with the below error: 

This happens very sporadically and with no pattern while none of the data sources are empty. Can anyone help with the possible resolution of this issue and throw some light on why this is happening? There are no content or information available on the web on this issue. 

[Sumanth_23]

hi @Anonymous - Had a question around the automation script that refreshes the data in the excel source files - does that delete and replace the excel files in source. would appear that the files are not available when Power BI is attempting to refresh the dataset. 

Also data in source files on Sharepoint and OneDrive will automatically synced to Power BI datasets - https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

Can you let me know if you have setup refresh schedules manually? 

If my response helped with your question please provide a 👍 and mark the post as a solution as this will help others in the community with a similar question. Thanks!