https://community.databricks.com/t5/get-started-discussions/power-bi-paginate/m-p/54942#M6246 <P>Hello,</P><P>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 below.&nbsp;</P><P><A href="https://community.databricks.com/t5/data-engineering/multi-value-parameter-on-power-bi-paginated-ssrs-connected-to/m-p/32186#M23455" target="_blank">https://community.databricks.com/t5/data-engineering/multi-value-parameter-on-power-bi-paginated-ssrs-connected-to/m-p/32186#M23455</A></P><P>However, I have end up with below error.</P><P>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:<BR />[PARSE_SYNTAX_ERROR] Syntax error at or near 'and'.(line 1, pos 84)</P><P>My Query:</P><P>== SQL ==<BR />="select * from table where Category='ABC' and (FiscalYear=Parameters!Year.Value)and (Month=Parameters!Month.Value) and (Program=Parameters!Program.Value)"</P><P>Thanks,</P> Fri, 08 Dec 2023 15:36:14 GMT TechMG 2023-12-08T15:36:14Z https://community.databricks.com/t5/get-started-discussions/power-bi-paginate/m-p/54942#M6246 <P>Hello,</P><P>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 below.&nbsp;</P><P><A href="https://community.databricks.com/t5/data-engineering/multi-value-parameter-on-power-bi-paginated-ssrs-connected-to/m-p/32186#M23455" target="_blank">https://community.databricks.com/t5/data-engineering/multi-value-parameter-on-power-bi-paginated-ssrs-connected-to/m-p/32186#M23455</A></P><P>However, I have end up with below error.</P><P>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:<BR />[PARSE_SYNTAX_ERROR] Syntax error at or near 'and'.(line 1, pos 84)</P><P>My Query:</P><P>== SQL ==<BR />="select * from table where Category='ABC' and (FiscalYear=Parameters!Year.Value)and (Month=Parameters!Month.Value) and (Program=Parameters!Program.Value)"</P><P>Thanks,</P> Fri, 08 Dec 2023 15:36:14 GMT https://community.databricks.com/t5/get-started-discussions/power-bi-paginate/m-p/54942#M6246 TechMG 2023-12-08T15:36:14Z