No data show in Query Errors when viewing errors

[Anonymous]

Hi,

The data input is local Excel file, and there are about 50 colums. When I finish the query and click "Close & Apply", there's an error message. Then I click "View Errors", but no errors show in the Query Errors as unusual. This is  and very strange.

I guess it must be the cells data format don't consist with the column format. But I can't position these cells exactly.

How can I solve this problem? Could anyone help?

(The screenshots are  just for sample.)

[Icey]

Hi @Anonymous ,

Is this problem solved?

Best Regards,

Icey

[Icey]

Hi @Anonymous ,

If you don't mind, please share me your local Excel file and your PBIX file, removing sensitive information.

Best Regards,

Icey