DataSet not refreshed due to field name change

[Fab117]

Hi,

My dataset is an Excel file that I update on a monthly basis (I simply overwrite the old Excel file with the new one).

There is one field name (title in my Excel) which is changing every month.

This causes an error when Dataset is refreshed

Hopefully, I don't need this field content => in Power Query, I removed it from column to be kept

But unfortunately, Power BI is still not able to update data set.

Any way to solve this without having to manually change the field name in the Excel?

Thanks

Fab

[negi007 · Accepted solution]

@Fab117  when you are importing data in power query, there code is using the name of column in the code, as i can see, promoted header/changed type/remove other columns step is where name of the columns are being used inthe code and when you refresh those names are not found so error is encountered.

to tackle this you can edit your code by right clicking the table name and then advance editor. here if you see any line where name of the columns are being used, you can either remove those steps from the code and make changes in the code such that name of the column is not used. 

[Fab117]

Hi @negi007 

Thank you very much looking at my issue.

In the advance editor, I deleted the part of the line containing my field name

And it looks my issue is solved.

New question: Is there a need to keep there other fields I know I won't use?

Can delete them also without any risk (just keeping the ones used in my report)?

Tks.

Fab

[negi007]

@Fab117 you can try to delete those fileds not needed and see if the the model is refreshing fine or not. and make sure you have the backup file just in case you have to go back to previous one in case of any issue.