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