Error says that “a column is not being found”

[Anonymous]

I would like to update a data set in powerBI having the transformation steps applied to the new (updated) data list.

But by replacing the data set, power BI sends me an error which says that “a column is not being found”. and It is the first empty column in data set.

Columns are not changed compared to the old data set. All same columns.

So therefore currently I am not being able to update my data.

Do you know where this error is coming from?

Thanks

[Anonymous · Accepted solution]

HI @Anonymous,

In fact, these error messages mean the updated records from the data source do not match the cache data structure. AFAIK, Power query is a step-based language, each operation will be recorded in these steps.
These query steps will log data structures and the change on data structure change into each query step and they do not auto-synced even if any change on the data source side.
When you do change the data structure on the data source side(e.g. change column name/type, edit/remove fields), the new records do not match these cached data structures and power bi will return the error message about 'key or field value not match'.
For this scenario, you need to enter to query editor to manually fix these data structure issues and publish to replace the old report.
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , In your steps you have to check for any rename. Right click and open advance editor If there is no additional rename before the error step, means something has changed at source.