Imke Feldmann provides some answers:
Have you ever come across the case where you open your dataflow and find 2 additional steps at the end of your query? Why are Power Platform Dataflows adding steps automatically at the end?
It will be a step that replaces errors on certain columns followed by a step that transforms these columns into text.
Read on to understand why.