Data Refresh Not Working - The column of the table wasn't found

[Anonymous]

Hello,

This is the message I get when trying to change the data source to a new excel. The columns are identical, along I did change the name of the column in Powerbi. But that should be an applied step that is applied to all new excel files as well, right? Any assistance would be most appreciated. Thanks!

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @Anonymous ,

In Power Query, if you have changed the column name in one step, the following steps which reference the original column name will return an error. I suggest you open Power Query, find the error steps, see if it's caused by the column name, change the column name in all code, then load the data, the error will disappear.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dakins]

Hey,

I followed the steps in this video when I changed data source and it worked perfectly.

Link: https://www.youtube.com/watch?v=_8dJ--ktU4c&list=PL3jNKxUiloIkJ7dUR0uRoG-xF0rbN0AN7&index=4&t=332s