Forum Discussion

Copper Contributor

Dec 03, 2019

Import Multiple Excel files from Sharepoint to Power Query "File Contains Corrupted Data" Error

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...

excel

Luki_Farhandika

Copper Contributor

Dec 04, 2019

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

Wyn Hopkins

MVP

Dec 04, 2019

Sounds like a similar issue here. One person suggested the fact that the files were bigger than 30MB was the problem https://community.powerbi.com/t5/Desktop/Sharepoint-excel-data-refresh-showing-corrupted-data/td-p/674816

Luki_Farhandika
Copper Contributor
Dec 10, 2019
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
- Wyn Hopkins
  MVP
  Dec 10, 2019
  OK, thanks for letting us know. One other thing to try is Pausing OneDrive sync when you're running Power Queries. Occasionally seems to cause issues.