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 without having my query to crash?
any recommended solutions?
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.
1 Reply
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.