topic Re: Passing Parameter from SSRS to Databricks user defined function in Data Engineering

Passing Parameter from SSRS to Databricks user defined function

Samit110978 — Fri, 16 Dec 2022 15:38:15 GMT

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

Re: Passing Parameter from SSRS to Databricks user defined function

Aviral-Bhardwaj — Sun, 18 Dec 2022 06:48:32 GMT

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

Re: Passing Parameter from SSRS to Databricks user defined function

Samit110978 — Mon, 19 Dec 2022 20:56:52 GMT

Thanks Aviral. I found the solution.

Re: Passing Parameter from SSRS to Databricks user defined function

AEW — Thu, 13 Apr 2023 21:27:36 GMT

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