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