Hello,

I am facing similar kind of issue.  I am working on Power BI paginated report and databricks is my source for the report. I was trying to pass the parameter by passing the query in expression builder as mentioned above. However, I have end up with below error.

ERROR [42601] [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query: [PARSE_SYNTAX_ERROR] org.apache.spark.sql.catalyst.parser.ParseException:
[PARSE_SYNTAX_ERROR] Syntax error at or near 'and'.(line 1, pos 84)

My Query:

== SQL ==
="select * from table where Category='ABC' and (FiscalYear=Parameters!Year.Value)and (Month=Parameters!Month.Value) and (Program=Parameters!Program.Value)"

Thanks,