Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Help needed with "DataFormat.Error: File contains corrupted data"

Morning All, I am struggling with trying to escape this error in Power Query. Basically, getting multiple files from SharePoint folder which are then filtered to only retain XLSX ones, but there see...

Need Help

Anonymous
4 years ago
ignore this, I found the file that was password protected finally. In my case, this seems to happen when extracting the Excel file's Content into another column which would then be expanded further to get to the various worksheets within the files. As I kept scrolling through the Contents column I noticed "Error" value and against this value I was able to get the file name and path. I have removed the password and hoping that should fix the issue.

Anonymous

Not applicable

4 years ago

ignore this, I found the file that was password protected finally. In my case, this seems to happen when extracting the Excel file's Content into another column which would then be expanded further to get to the various worksheets within the files. As I kept scrolling through the Contents column I noticed "Error" value and against this value I was able to get the file name and path. I have removed the password and hoping that should fix the issue.