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 ...
The file might be set to confidential or must be opened with a password. In both cases the XML data in the file is encrypted and therefore PQ can not read that file.
Andreas.
There is no password on the file. I can open the file without any problems, I just can't import from it via Power Query.