Openpyxl corrupt xlsx file with PowerQuery table
If you open and write an xlsx file containing a Powerquery table, then when you open the file, an error will appear: There is an error in some of the content in the filename.xlsx book. Try to restore? If you trust the source from which the book was obtained, click "Yes"
When restoring the workbook, Excel reports the deletion of a part of the document:
<removedPart>Remote component: External data range. </removedPart>
All powerquery tables is dropped, but tables data remains.
Samples: