File contains Corrupted data error in Excel power query

Hi Dineez18 ,

The "File contains corrupted data" error can indeed be frustrating, but let's work through some steps to potentially resolve this.

Given the steps you've already tried, including restarting, clearing temp files, and checking for issues within Excel, it seems you've covered some common troubleshooting ground. The error you're experiencing typically points to issues with the file format or compatibility between the file and the Power Query connector.

Action Plan:

1. Verify File Format and Compatibility: Ensure that the Excel files you're trying to connect to are in a format supported by Power Query. Power Query works best with .xlsx files. If your files are in another format (e.g., .xls), consider saving them as .xlsx and then try connecting again.

2. Check for Special Characters in File Names or Paths: Sometimes, special characters in the file name or the path to the SharePoint location can cause issues. Ensure there are no special characters or spaces in the file names or paths. Similar post: DataFormat.Error: File contains corrupted data. Details: [Binary] - Microsoft Community

3. Match Power BI Desktop and Microsoft Office Versions: If you're using Power BI Desktop, ensure that its bit version (32-bit or 64-bit) matches the bit version of Microsoft Office installed on your computer. Mismatched versions can lead to connectivity issues.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.