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