Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

[Excel integration] Renaming column in excel table leads to error

Hello community,

a colleague I support has a problem with renaming columns in an Excel table imported in Power BI desktop.

Upon renaming an column header name in the Excel table and saving this change, this column will not be found in the Power BI Desktop Query Editor.
Reverting the header name change let’s Power BI show this column again.

This screenshot shows this error:

 

 

I unfortunately can’t reproduce this error. Has anyone experienced it and knows a workaround/solution?

Thanks in advance

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I already found a solution in another topic here that I didn't find prior.

    In short:
    Go to External Data command group, edit the query in the Power Query Editor and from there use the extendend editor to edit column names in the query to match changed column names from the Excel source file

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I already found a solution in another topic here that I didn't find prior.

    In short:
    Go to External Data command group, edit the query in the Power Query Editor and from there use the extendend editor to edit column names in the query to match changed column names from the Excel source file