Error "the specified package is invalid. the main part is missing" when loading spreadsheet

[Anonymous]

I receive this error when I try to load an Excel spreadsheet to Power BI.

There are several tabs within the spreadsheet which I load. Based on my search, it seems like the issue was to do with formatting (specifically fonts).

But what isn't clear is where the issue originates. If I change the font on one of the tabs, the data loads. But the odd thing is I can change the font on any tab and the data will load - it doesn't necessarily have to be a specific tab or all tabs.

There is conditional formatting and other formatting in the spreadsheet. The spreadsheet is an alteryx output, and therefore I've tried adjusting the font settings there, but to no avail. 

The data is confidential so I can't attach it here unfortunately.

[v-xicai]

Hi @Anonymous ,

You may refer to the links:

https://community.powerbi.com/t5/Service/Data-Refresh-Error-The-specified-package-is-invalid-The-main/td-p/495214 ,

https://stackoverflow.com/questions/23239029/openxml-spreadsheetdocument-open-get-exception-the-main-part-is-missing,

https://www.codeproject.com/Questions/1139723/The-specified-package-is-invalid-the-main-part-is .

Best Regards,

Amy

Community Support Team _ Amy

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