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...
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 🙂