Forum Discussion
shahid_tanmoy00
3 years agoRegular Visitor
Can I use a textbox input into a sql query source
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.
2 Replies
- ppm1Solution Sage
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_tanmoy00Regular Visitor
Can you show me as in a code how I would do this?