You’re offline. This is a read only version of the page.
Hello,
I am trying to convert Xls to Xslx for the PowerBI dataset refresh from Power Automate. I followed Power automate forum discussion to rename the file from xls to xlsx but the file corrupts every time.
Please suggest to me an effective approach to convert xls to xlsx without any third-party paid services(Data Privacy issue).
Thanks in advance.
Hi @Anonymous
How are you getting on?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
Hi Selva,
I think the only way you are going to achieve this is to copy the content from Excel using an Excel Script and then copy it into a new XLSX file. If the original XLS was using a table, you could use the get rows excel action and then save to XLSX but without trying i'm not sure, does XLS support the Power Automate get table?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
Share
Report
All responses (
Answers (
2
