Passing Parameter from SSRS to Databricks user defined function

[Samit110978]

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

[Aviral-Bhardwaj]

can you share full code and dataset by that we can also debug this

[Samit110978]

Thanks Aviral. I found the solution.

[AEW]

Hi Samit, could you explain your solution? I'm having the same problem. Thank you!