Automate column name change error in Power BI desktop

The error wont actually be caused by the column name changing, but by any transformation steps applied to the column which by default reference the column name.

You should review the transformations applied to the column and identify which ones are causing the error.

If your column layout is consistent, you could try editing the M code for your transform steps  to reference the column by it's index instead of the column name.

see: https://stackoverflow.com/questions/50113354/how-to-refer-columns-in-power-query-by-index-or-position