Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

An I can Passing Parameters in Query?

 

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.

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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.