I am trying to pass parameter from SSRS to User Defined Function in Databricks which in turn will return table that will be shown as output in report.

I tried below calling function from SSRS, but it looks like parameter value is not passed. I have directly executed this function in Databricks and it works fine.

Dataset:

SELECT  *

FROM      <Schema>.<UDF> ('{Date1}}')

Parameters Tab in Dataset:

ParameterName : @Date1

ParameterValue: '{Date1}}'

Parmeters:

Name: Date1