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