Forum Discussion
Power Query doesn't read an Excel file
I have an Excel file produced by an external database (a data export). Attempting to read this file in Power Query I am presented "File Contains Corrupted Data message". I can Open the ...
Thanks, I can open the file without issue in Excel. I just can't read it in Power Query (either in Excel or Power BI).
There is no password on the file.
Post a download link of such a file here.
Andreas.
Sorry, it's commercially sensitive data.
Unzip the Excel file and try to import the file \xl\worksheets\sheet1.xml
What happens?
Andreas.