Forum Discussion
Helper VUnable to load Excel file because we couldnt understand its format error?
Hi. The warning is saying that one of the files has an issue. I have read about this before. It's like the excel file wasn't saved properly in xlsx. Most users solve it opening the excel files from sharepoint at their excel desktop and save it again checking the format is xlsx.
You can read something similar in this post: https://community.fabric.microsoft.com/t5/Service/DataFormat-Error-We-were-unable-to-load-this-Excel-file-because/m-p/4803572
I hope that helps,
Super UserHi mike_asplin
Reason might be one of Excel files in SharePoint is corrupted or not a valid .xlsx structure even if it opens in Excel
As Desktop it works where Power BI Service it fails on invalid internal XML parts (customXml)
So, in Power Query you can temporarily filter files one by one or add a column which will flag the file that has error
```M
try Excel.Workbook([Content]) otherwise "Error"
```
Ensure file is not in .xls format and it shall be of .xlsx format and not partially corrupted from the upload
mike_asplinAll files were xlsx and they all work fine in the desktop so dont think thi would have helped. i opened and resaved every file and seems ot have fixed it so didnt try your suggestion. Thanks