How to pass user input of free text tp stored procedure

[Anonymous]

Hi,

I have a stored procedure that takes the user input and performs full text search in the SQL DB. and then returns the matched rows. How can i create a view/report with a text box that takes user input and sends it to the stored procedure as a parameter.

this way the user can interact in real time with the report by changing the free text and seeing search results.

[amitchandak]

@Anonymous , refer if this can help

https://www.fourmoo.com/2020/10/08/power-query-m-passing-parameters-dynamically-to-a-sql-server-query/

[Anonymous]

Hi Amit,

How can I create a text box for the user to type their input there?

Additionally, the box needs to be linked with the parameter being passed

[amitchandak]

@Anonymous , In place of the list of value, if you keep "Any" you should be able to enter new values

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4/

Also check this

https://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/

[Anonymous]

@amitchandak is slicer the only way to capture user's input?

Because the slicer forces me to pick a value from a dropdown or select a value from a list based on the column on which the slicer is built.

But I want to be able to put the parameter into the page (just like we put column names) and enter free text.

[v-kelly-msft]

Hi @Anonymous ，

Try text filter,see below reference:

https://exceleratorbi.com.au/text-filtering-power-bi/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!