Forum Discussion

Anonymous

Not applicable

7 years ago

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 do...

Microsoft Employee

7 years ago

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
Not applicable
7 years ago
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
  Microsoft Employee
  7 years ago
  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
    Not applicable
    7 years ago
    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,

Related content