Reading WPS Spreadsheet

[Anonymous]

I am connecting to a report folder containing multiple Excel workbooks of the same layout.  I have a user in China who uses WPS Office (WPS spreadsheet is said to be compatibale with Excel)  Excel does not have a problem with the file - but Power BI will not recognize it as an Excel file.  All the workbooks in the folder process fine if I remove the WPS/Excel workbook.  If I re-create the file (copy/paste all values) into an Excel file, the workbook is then recognized by Power BI.  I suspect there is something in the XML file structure that Power does not "like".

How can I work around this problem - user in China is a third party organization - so asking them to "upgrade" is not an option.  I need to receive and process these files daily.

[v-danhe-msft]

Hi @Anonymous,

Based on my test, Power BI Desktop could not support the format of WPS excel file, but you could change the format of your file from et to xlsx like below picture:

And click "yes" withe below dialog:

Now you could use Power BI Desktop to connect it.

Regards,
Daniel He

[Anonymous]

Daniel,

We receive the WPS spreadsheet file from our third party with an .xlsx extension on it - I do not know how they created/saved it.  I do not see an .et extension on the file.  Opening with Excel on our end and resaving does not correct the problem.

What exactly are you suggesting? That our third party use file manager to rename the file with an .xlsx extension? Or should they send in the .et format and we "sort it out" on our end?

Thanks for your reply.

[v-danhe-msft]

Hi @Anonymous,

Based on my test, Power BI could recognize below excel files (.xl;.xlsx;.xlsm;.xls). From your description, if all your files extension name are .xlsx, the Power BI could recognize, if it could not recognize, could you please offer the error meassgae?

Regards,

Daniel He

[Anonymous]

@v-danhe-msft - Okay below is a screen shot from the query editor - 2 of the "xlsx" files below return an error - these are the WPS files in the folder. 

 

[v-danhe-msft]

Hi @Anonymous,

Based on my test, I could not reproduce your problem and all the files could work on my side, could you please share some sample file to upload these test files to OneDrive or Dropbox and send the link here if possible?

Regards,

Daniel He

[Anonymous]

@v-danhe-msft Daniel, I am happy to share test file with you via OneDrive - How do I grant you aceess to my OneDrive folder?  Don't I need an e-mail address?

Regards,

[Anonymous]

@v-danhe-msft Daniel - below is the link to OneDrive with an example WPS spreadsheet that will not load.  I assume I can grant you access when you request.

https://technicolor-my.sharepoint.com/:f:/r/personal/michael_baker1_technicolor_com/Documents/PowerB...

Regards,

[v-danhe-msft]

Hi @Anonymous,

It seemed I could not have access to your file:

Could you please check again?

Regards,

Daniel He

[Anonymous]

Daniel,

@v-danhe-msft My IT policies will not allow me to share my OneDrive folder - I have sent the file to your email address.

Regards,

[Anonymous]

Daniel, @v-danhe-msft

Error message below: (Sorry I could not copy/paste the screen shot...)

Unable to connect

We encountered an error while trying to connect.

Details: "The input couldn't be recognized as a valid Excel document."

Regards,