Unanswered

Convert XLS to XLSX for PowerBI refresh

(4) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AM-06061933-0 7 on at

Like (0)

Report
Copy link

Link copied!

Does anyone have an answer for this? I have an automated excel report in XLS from a third party that I would like to incorporate to a Power BI report, but it does not allow the queries to refresh. I can manually save the file each day or use Power Automate Desktop but I need this done early for my European counterparts - thus using Power Automate Desktop is out of the question. Thanks!

Was this reply helpful? Yes No