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 ...
It seems like Power Query is having trouble with how the file is being overwritten, even though Excel handles it fine. Here are a few suggestions to address this issue:
Check File Encoding and Format: Ensure that the file's encoding or format is consistent and correct. Sometimes, the way the file is saved or updated could introduce inconsistencies that Excel handles but Power Query doesn't.
Automate the Resave Process: If opening and resaving the file in Excel solves the issue, you might automate this step using a VBA script or a PowerShell script to run before loading the file into Power Query.