Can I use a textbox input into a sql query source

[shahid_tanmoy00]

Hi All :), 

I have a sql query that is connected to sql database server. 
I have a sql code that runs on a refresh but I want I want to build a tool out of it that restricts the code to whatever order number the user is looking for information about. 

I feel like this is not a thing in PowerBI but is there anyway a dax code in advanced editor can reference a textbox that is on the dashboard that a user has inputed a order number too. 

[ppm1]

Have you considered using direct query mode with a dynamic M parameter?

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Pat

[shahid_tanmoy00]

Can you show me as in a code how I would do this?