The expression contains unrecognized token "%1!s!". If "%1!s!" is a variable, it should be expressed as "@%1!s!". The specifed token is not valid. If the token is intended to be a variable name, it should be prefixed with the symbol. The specifed token is invalid. If the token was intended to be a variable name, it should be prefixed with the symbol.

Community Notes

This occurred when attempting to construct a date time expression in the expression builder.

The expression builder did not like the syntax I used for retrieving Hour from date time.

I used DatePart(HOUR,GETDATE()) and it wanted DATEPART("HOUR",GETDATE())

PipelineErrorCodes