Forum Discussion
Refresh Error: Refresh failed: Archive file cannot be size 0.
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 sharepo...
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!