I am using Plumsail Documents in Power Automate to convert an .xls file to .xlsx. I've confirmed the .xls file is indeed in .xls format and also not corrupt. The flow is successful, but the following error persists when attempting to open one of the .xlsx files created with the flow: "This workbook couldn't be opened because the file format may not be matching with the file extension." As can be expected from this error, my Power BI Service report is kicking out the following error when refreshed: "Data source errorDataFormat.Error: File contains corrupted data.. ;File contains corrupted data.. The exception was raised by the IDbCommand interface. "
Hello @bulldoganalytics,
Please double-check how you save the result xlsx file. Make sure to specify the .xlsx extension in the action that saves the file if you use it in your flow.
This is my test flow that works ok:
if the issue persists share the source xls file and I'll try to reproduce it.
Best regards,
Petr
Plumsail team