Recommended solution for column header changes

[vjnvinod]

Hi,

if my column header name keeps changing every month in excel dump, how do i fix that automatically in powerBI?

for instance from Technology to Tech...etc

How do i fix this automatically without having my query to crash?

any recommended solutions?

[MFelix · Accepted solution]

Hi @vjnvinod ,

Without knowing the type of data you are refering but if you have a promote first row to headers (and your columns are always in the same order) I would delete that step, remove the first row and then make the names manually, so you would have column1, column2, and so on and not the actual names.