Expression.Error: The column 'Column81' of the table wasn't found

[ALPOM]

Good day,

I have removed a column in my excel source data and when I refresh power bi, below error message popped out.

'Expression.Error: The column 'Column81' of the table wasn't found'

Please advice how to fix. Thank you.

[v-yalanwu-msft]

Hi, @ALPOM ;

Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi, @ALPOM ;

Power Query is telling you that this column name doesn't exist in your dataset. Check if you have your column name (including any capital letters, spaces, etc). If the removing column is a step in your query click on a previous step and check what the column name is exactly.

Can you post a sample of your M code that is erroring out? 

[Expression.Error] The column '<column title>' of ... - Microsoft Power BI Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ronrsnfld]

Remove the reference to "Column81" whereever it is referenced. 

It is likely in the M Code that underlies the Query (Home=>Transform Data=> Home =>Advanced Editor..

Depending on how often you will be changing your data source structure, it is possible to write M-Code where the column references are dynamic, but the learning curve may be steep.