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 ...
I 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 🙂