Errors when uploading data

Hi Anonymous 

Sorry I’m not quite sure about “I cannot seemt to find an upload button to upload the excel spreadsheet.” Does it means you edit it in query editor and then apply to the desktop? could you please specify more details? That would be preferred if you could share us the detailed error info as well.

Based on my research, this phenomenon probably happens when your columns contain data that doesn't match the data type of the column. This is allowed in Power Query, but not when the data is loaded.

An example would be numbers with fractions, while your column's data type is whole number.

Finding the errors: visually check if the actual data in each column matches the data type of the column.

Solving the errors: make sure the data types of the columns match the data types of the values in the columns.

Please share us more info if the problem still exist. Thanks!

Best regards,

Dina Ye