Forum Discussion

ashukla2's avatar
ashukla2
Regular Visitor
3 years ago
Solved

Best way to modify parameters for advanced editor

I have a SQL database that I generate new queries for through the Advanced Editor. To get some customability in the query, I created a couple parameters and reference those in the advanced editor. Ho...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi ashukla2 ,

     

    If you want to bind a parameter, you need to under DirectQuery mode:

    Besides, you should check if your query use your parameter correctly.

    Here is my example:

    When I change the parameter in power query, the data of TESTTABLE will change accordingly:

     

    Best Regards,

    Jianbo Li

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

     

     

     

     

ashukla2's avatar
ashukla2
Regular Visitor
3 years ago

I followed the steps, however I after I bind a parameter to a set of values and make a slicer for it. When I change the value of the slicer, the parameter is not changing. I've read that the query needs to be a DirectQuery, but regardless of that shouldn't the actual parameter that I bound to change as well when I preview it under 'Transform Data'? The parameter stays as the default value I set it to.

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi ashukla2 ,

 

If you want to bind a parameter, you need to under DirectQuery mode:

Besides, you should check if your query use your parameter correctly.

Here is my example:

When I change the parameter in power query, the data of TESTTABLE will change accordingly:

 

Best Regards,

Jianbo Li

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