Renaming columns by another table and changing the naming without breaking existing reports
I have a table (let's call it: rename_table), which is used to rename columns in other tables in a PowerBI report. The "rename_table" contains two columns: original_column_name and new_column_name. The renaming of columns in other tables is done in M-query with:
I have the following problem. I want to change the new_column_names (i.e. overwrite the rename_table) without breaking graphs that use the current new_column_names. Is there any way to do it? From my tests I haven’t found a way to do it. Manually renaming the columns is not practical.