Forum Discussion
Problem with auto detected data from Excel file
Problems with legacy Excel files (xls instead of xlxs) are well known and documented here:
https://docs.microsoft.com/en-us/power-bi/desktop-access-database-errors
or here for example: https://social.technet.microsoft.com/Forums/en-US/cb4da941-6e36-4447-8c10-1582ae6a59b8/power-query-not-recognizing-values-stored-in-xlsfile?forum=powerquery
So your best bet is to transform to csv or xlsx.
Problems with legacy Excel files (xls instead of xlxs) are well known and documented here:
https://docs.microsoft.com/en-us/power-bi/desktop-access-database-errors
or here for example: https://social.technet.microsoft.com/Forums/en-US/cb4da941-6e36-4447-8c10-1582ae6a59b8/power-query-not-recognizing-values-stored-in-xlsfile?forum=powerquery
So your best bet is to transform to csv or xlsx.
