Forum Discussion
Solved
Pass parameter to query
Hi please help, how to pass parameter to a query. I have to followign situation: - have created a parameter in Power query of PBI = Parameter1 - have a query QUERY1, which downloads a data (from S...
Yes, you will need to change Query1 to receive parameter nad then call Query1 as
result=Query1(Parameter1)
Hence your Query1 would become
(Parameter1)=>
Let......(code of the query)
filter_field=Parameter1 (somewhere here is the filter condition base on the value of Parameter1)
..........
in ....
Exactly, this is also working, but the value read from the table parmtable is not passed to the QUERY1, the QUERY1 is still using the default value of Paramter1.
Yes, you will need to change Query1 to receive parameter nad then call Query1 as
result=Query1(Parameter1)
Hence your Query1 would become
(Parameter1)=>
Let
......(code of the query)
filter_field=Parameter1 (somewhere here is the filter condition base on the value of Parameter1)
..........
in ....