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 done I removed both the steps and save the dataflow, and then when I open the dataflow again I see below 2 steps again, (being added automatically by the Power Query)
How do I avoid those 2 steps getting added automatically.
6 Replies
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.smjzahid
Can you try the following:
Go to Data Flow and edit, Select Project Option and Options in Home Tab, Untick "Automatic Detect column types. . . .".
It is supposed to remove automatic type change but try if it works for your issue as well.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Did you figure out how to stop it? I have the same issue and the suggested tip didn't work.
I have the same problem. It keeps transforming a date column to text.
