Error when column name change

[tiphanieg]

Hello,
On a csv file that I manipulate on POwrrBI Desktop, there is a column that changes its name but when you update the report data, there is an "error" because the column name is no longer the same. Is it possible to fix this error or should the column always have the same name?

[az38]

Hi @tiphanieg 

if this column changes its name dinamically - the better way as I see is to remove first row from data source right after data load, remove automatic operation "use first row as a header", then rename all of your columns manually

do not hesitate to kudo useful posts and mark solutions as solution
Linkedin