Make sure you type in expressions inside the expression builder. Otherwise, ADF is interpreting your input as a query string. Inside the Expression Builder, you can just use string interpolation by putting the query and {$parameter} inside double quotes w/o concat: https://learn.microsoft.com/en-us/azure/data-factory/concepts-data-flow-expression-builder#string-interpolation
Error column operands are not allowed in literal expressions adf
i am getting this error Column operands are not allowed in literal expressions.
How can i append an expressions with string in dynamic query while creating a source dataset in dataflow.
3 additional answers
Sort by: Most helpful
-
Brian Polk 11 Reputation points
2022-02-16T16:37:42.09+00:00 I just had this same exact issue. Check how you are setting your default values on data flow parameters. Could possibly be in other places too. When setting up the input parameters under debug settings, just using literals results in red outline and indicates an issue. I removed the toString('Parameter1') I originally had and ended up leaving everything blank there. On the data flow its self, I set default values for debugging purposes and used the "Parameter1" syntax. When calling the dataflow via a pipeline it forces you to choose between pipeline expression or data flow expression. Originally i had pipeline express with @ hide ('Parameter1') with the Expression checkbox checked. I changed this to data flow expression and used the "Parameter1" syntax and after that, I was finally able to resolve this error. This is a terribly poor and undocumented issue that should be made clearer
-
Manuel Bustamante 47 Reputation points
2022-03-31T21:29:34.27+00:00 @Anonymous this worked for me. Just keep in mind that in the pipeline you must uncheck column expression when you are passing the parameters!!!!!!
- Pipeline. this is how I pass the parameters to the data flow:
- Dataflow: these are the parameters inside the dataflow:
- Dataflow: this is my source sink inside the dataflow:
- Dataflow: this is the expression builder of the query I use inside the source sink:
-
Manuel Bustamante 47 Reputation points
2022-02-11T15:22:53.21+00:00 Hi all,
I'm getting the same error. Did you manage to solve it?