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

[Anonymous]

I know there have been topics on this error, but I've reviewed them and they haven't been helpful.  I am trying to add a custom column with the absolute value of column "Amount".

Step 1:

Step 2 (causing the error):

Based on other threads it would seem to be a typo, however, that doesn't seem to be the case here.  Additionally, I have 4 Excel files like this that I'm importing with the same steps - 2 work and 2 don't.

Much obliged for any ideas.

[v-shex-msft]

Hi @Anonymous ,

If you can please share a pbix file with excel files for test, it is hard to troubleshoot from snapshot.

In addition, any data structure changes on your datasoruce side? If a new data structure cannot match with the old structure(cached in query steps), it will also cause the issue. (invoke missing table fields)

Regards,
Xiaoxin Sheng