Forum Discussion
Power BI Paginated Report Parameter
Hello Everyone,
Currently I am working on Power BI paginated report by using Azure Databricks as source. I have installed ODBC in my local to access the data from databricks to Power BI report builder.
I have successfully pull the data from databricks to Power BI Report builder and show them in the table. Now I have to add the parameters to the report and I have tried the below approach to pass the parameter in report and it wasn't success.
In the Querymode, I have created expression by using below query.
="select * from factmonthly where Category='ABC' and ProgramId=Parameters!ProgramId.Value and Year=Parameters!Year.Value and Month=Parameters!Month.Value"
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 '!'.(line 1, pos 108)
== SQL ==
select * from factmonthly where Category='ABC' and ProgramId=Parameters!ProgramId.Value and Year=Parameters!Year.Value and Month=Parameters!Month.Value
------------------------------------------------------------------------------------------------------------^^^
at org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$.runningQueryError(HiveThriftServerErrors.scala:48)
at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.$anonfun$execute$1(SparkExecuteStatementOperation.scala:611)
at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)
at com.databricks.unity.EmptyHandle$.runWith(UCSHandle.scala:124)
at org.apache.spark.sql.hive.thriftserver.Spar...
----------------------------
Query execution failed for dataset 'FoodObligationEstimatesds'.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.
At the end, I have to deploy this report in Power Bi Service by implementing RLS. Is this possible in Power BI report builder ? or Do we have any other alternates.
Thanks
No RepliesBe the first to reply