Forum Discussion
Data Refresh Error: The specified package is invalid. The main part is missing.
Hello, I am experiencing an error that I haven't experienced yet. During a refresh in the PBI Service, I am receiving the below error: The table is similar to any other table in the ...
themew
Advocate I
Advocate II was receiving the same error.
The problem for me was my source file was saved as 'Strict Open XML Spreadsheet' format, not 'Excel Workbook' format.
Both files are saved as a '.xlsx' format, so you wont easily realize its wrong, so I opened the source file in Excel, 'save as' and change the file type to 'Excel Workbook.xlsx'. I was then asked if I wanted to replace the 'Strict Open XML' version, and I said yes.
This worked for me and my refreshes were back to normal.
Thank you.It helped me 🙂