Forum Discussion
GraceTCL
Helper II
Helper IIError: Detected type mismatches
hi can anyone advise on this error "Detected type mismatches" during query where error details as follow. This is despite the fact that I have reverted the change type of the source data back to its ...
I ran into a similar issue that was giving me a type mismatch in similar circumstances.
Check if any of those "Changed Type" steps in your PowerQuery flow assign a data type you don't intend. Mine was fixed because it was assigning a text field as int.64 by default, this was creating a type mismatch when I then tried to convert to text.
Not sure exactly why it fixed it for me, but your issue seems similar to the issue I had.