Forum Discussion

Jerome_C63's avatar
Jerome_C63
Frequent Visitor
3 years ago

Modified column header

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

Tips and Tricks

2 Replies

  • 1Daniel993's avatar
    1Daniel993
    Helper III
    3 years ago

    Hello, you could try with code M in powerQuery

    Questions always do you have the same numbers of columns?

  • Jerome_C63's avatar
    Jerome_C63
    Frequent Visitor
    3 years ago

    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).