Forum Discussion
tomas12344
Helper III
Helper IIIPass 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 ....
tomas12344Helper III
Helper IIIExactly, 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.
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalYes, 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 ....