Forum Discussion
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 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?
7 Replies
You can read this forum: https://community.powerbi.com/t5/Desktop/File-contains-corrupted-data/td-p/548620
- I don't know why this is happening but what method are you using to import the files? From SharePoint Folder? Is it a very long folder path name?
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
- 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
