"QUERY Execution error " while deploying the model.
I use the DB tables directly. I dragged the db table on to the story board and used BI integration wizard to initially get all the values from that table. Now i want the table to take dynamic values form the input form. For this i have used the SQl statement from the input field.
Ex: input form: X and Y. The table will take two values.
The sql statement : "Select * from Table name where FieldX = ' " & @X & " ' " AND FieldY = ' " & @Y & " ' " "
When i deploy this i get a error "QUERY EXECUTION ERROR"
But when i map the Input fields directly to the corresponding values i get the output.
Please can any one help.