Forum Discussion
Solved
Recommended solution for column header changes
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 ...
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.
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.