Dec 03 2019 12:00 AM
So I need to import multiple excel files from SharePoint with Power Query. During loading the data, Excel showed error notification which said "Files Contains Corrupted Data". The funny thing is when I tried to import those same files from local folder with Power Query, it worked fine. All the files extension are the same ".xlsx", containing only 1 sheet with the same quantity of row.
Does anyone ever encounter such similar problem and already have a solution?
Dec 03 2019 04:30 PM
Dec 03 2019 06:03 PM
@Wyn HopkinsHi thanks for the reply. Yes I indeed use the get data function --> From SharePoint Folder, also the folder path name is short such as https://xxxxxxxx.sharepoint.com/sites/xx
Dec 03 2019 07:07 PM
Dec 03 2019 07:11 PM
Dec 09 2019 07:57 PM
@Wyn Hopkins Hi thanks for the reply
The total files in said folder were 500 MB. On the other hand, I have another SharePoint Site with 100 MB file and successfully fetch its data with Power Query.
As for now, the error notification has been come and go randomly. At times, I can refresh the power query just fine. When it showed the error notification, I just close and load the excel file with power query and refresh the SharePoint Site several times.
The problem now seems not too catastrophic, but its getting annoying when I need the data urgently and I get the error with no absolute solution
Dec 09 2019 10:49 PM
Feb 11 2021 11:14 PM
You can read this forum: https://community.powerbi.com/t5/Desktop/File-contains-corrupted-data/td-p/548620