Forum Discussion
How to Stop - Replace Error and Rename Column Steps in Power Query
In my dataflow I note that below 2 highlighted steps (Replace Errors, Renamed Columns) are getting inserted automatically by the Power Query (I dont want those 2 steps to be added). What I have d...
You could try to define dataypes for each column.
I had the same situation:
and this is caused that all columns had "Any" datatype
when i converted back to the right datatype problem was resolved.
Let me know if it helps.
This was the solution for me. Once I explicitly defined the data types for all columns, the "Replace Errors" step was not being automatically generated anymore.