passing parameter to sql query

Hi Arnoh,

As I know, you could achieve this by  M query.

You could try to write hard code in query like below “select *  from test where name=’a’”, then create a parameter

Then apply this parameter to query , you need to edit query like below

let

    Source = Sql.Database("servername", "newsql", [Query="select *  from test#(lf)where name ='"&namep&"'"])

in

    Source

The you could change value in parameter and run the query. You could refer to Pass parameter to SQL Queries statement using Power BI for details

Best Regards,

Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.