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

[Anonymous]

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

[Anonymous · Accepted solution]

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