Forum Discussion
Advanced editor- Manage parameters which is obtained dynamically
Anonymous ,
According to your description, my understanding is that you are going to set the result of 'Query 1' as the values of Parameter 'New1'. We can use the Query List in Parameter to meet this requirement, but there is a limitation, when we change the parameter ‘New’, we need to apply the change first, then the new result will be returned to parameter ‘New 1’.Please refer to the following steps:
Firstly, we create a query (in my environment, it is named as Query1) with the parameter ‘New’, please refer to the following query:
let Source = Sql.Database("**", "**", [Query="**"&New]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"**", type text}}) in Table.ToList(#"Changed Type")Then we can create a new parameter with this list like below:
Regards,
Lydia
Anonymous ,
According to your description, my understanding is that you are going to set the result of 'Query 1' as the values of Parameter 'New1'. We can use the Query List in Parameter to meet this requirement, but there is a limitation, when we change the parameter ‘New’, we need to apply the change first, then the new result will be returned to parameter ‘New 1’.Please refer to the following steps:
Firstly, we create a query (in my environment, it is named as Query1) with the parameter ‘New’, please refer to the following query:
let
Source = Sql.Database("**", "**", [Query="**"&New]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"**", type text}})
in
Table.ToList(#"Changed Type")
Then we can create a new parameter with this list like below:
Regards,
Lydia
what should be there @ place of 'source' and '**' in Table.TransformColumnTypes ?