Modified column header

[Jerome_C63]

Good morning to the Power BI community,

From the Excel files that I receive every week concerning incidents by department, I have built a Power BI report.
Sometimes, in the Excel files, the name of the department in the column header (e.g. Marketing) is modified by a person and therefore, during the refresh, I get an error during the transformation indicating that the "Marketing" column does not exist.

Currently, I manually check the column headers or I modify the transformation steps in Power Query Editor so that the refresh works.

I would like to know if there is any way to manage this type of problem in an automated way?

Thanks in advance

[Jerome_C63]

Hi 1Daniel993

Sorry for the delay but I am full at the moment.
Yes, I normally have the same number of columns (hopefully the person who changes the header name doesn't add any more).

[1Daniel993]

Hello, you could try with code M in powerQuery

Questions always do you have the same numbers of columns?