Error in excel connection

[luisreyes]

I'm trying to desing a dashboard with multiple excel books as data source (i have 3 excel books that are not related and are connected)  , today i received an excel from another company, when i try to make the connection it show the following error:

Details: "The document cannot be opened because an invalid part with an unexpected content type exists.

[URI de parte=/xl/worksheets/sheet1.xml],
[Tipo de contenido=application/xml],
[Tipo de contenido esperado=application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml]."

All books area in .xlsx format, Power BI and office are 64 

[Vijay_A_Verma · Accepted solution]

Looks like they have used coding to create the Excel file and some xml is missing in this created Excel. This happens frequently when third party code is used to prepare an Excel file.

Only option is to correct this Excel file. You can open this Excel file in Excel desktop (if you don't have Excel desktop, use Excel online) and save it again as a .xlsx file. This newly saved Excel will be corrected Excel file.

Now, your file will be allright and you can use this new file to import into Power BI.