Based on your information, it seems that is a comman error message type mismatch, I cannot see something specific in it as I'm not clear about your quey.
The Excel file is on Sharepoint. I connect this datas and i changes formats.
I'm afraid that may caused by the changed formats.
By research, here is a similar thread which including some suggestions which may help you. You could have a reference of it.