Forum Discussion
wherdzik
2 years agoHelper III
An error occurred in the ‘Transform File’ query. Expression.Error
Can someone please guide me with this error. I had a PowerQuery connection to all of our budget files filtered for test string "2024 budget". The first time I ran this, no issues everything came th...
lbendlin
2 years agoSuper User
You don't have a row 83 (actually 84 but counting starts at 0) in your previous step #"Removed Errors". Most likely the number of errors is dynamic, and then so is the remaining row count.
Refactor your query so you do not need to remove errors.