hard20 pts · first answer countsexcelpower-query

Query breaks after a column rename

A Power Query refresh fails with "Expression.Error: The column 'Amount' of the table wasn't found". The source file now calls the column "Net Amount". What is the cause?

A.Power Query cannot read any columns with spaces in their namesB.The query needs to be deleted and built againC.Steps refer to columns by name, and the old name is goneD.The source file has more than 1,048,576 rows

Discussion 0

Join free to post in the discussion.

Query breaks after a column rename

Discussion 0

Related questions