Forum Discussion
Reading WPS Spreadsheet
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.
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
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,
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.
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
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,