An I can Passing Parameters in Query?

[Anonymous]

Hi,

I need help.

I want use parameter for curtumize my query in DirectQuery.

Exemple:
1 - User go write ID: '0036565' (Filter)
2 - Query "Select *

                 from people

                 where ID = '0036565'
3 - All views change.

Can help me?

Tks all.

[v-juanli-msft]

Hi @Anonymous 

Create a blank query

let function_name=(parameter_name as text)=>
let
    Source = Sql.Database("server name", "database name", [Query="SELECT *#(lf)  FROM [power bi test].[dbo].[Sheet1$]#(lf)  Where [BUSINESS_DAY_IN_MNTH]="&parameter_name&""])
in
    Source
in  function_name

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.