Forum Discussion
Error when editing column names in Advanced Query Editor
Two columns were added to the source table which have the same names that columns already loaded were changed to. So I went into the Advanced editor and changed the names of the already loaded columns again to be different from the new columns added to the table. The preview showed the new columns added to the table. But then when close and apply, I get an error saying "Something went wrong: An error occurred while rendering the report" with no additional info other than a "Copy details" option and a "Report this issue". What is the problem? Is there something else I need to do in order to change the column names?
Hi Anonymous
I don't see any issues with the M code no that you have suffixed the names with "old".
I was in a similar situation and I did create a new connection to the file and on the new connection I replaced the M code shared by you.
Can you give it a try If it doesn't work you have to give the file used in it with only one row and you can replace all the values in that row with test data.