Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Want the appropriate syntax in LIST to view the data (Azure SQL database). We have two parameters(list)- 'New' & 'New1". When we select the field from the parameter 'New', we execute 'Query 1' which shows the list. Now, we want to pass the values from executed 'Query1' to the 'New1' parameter in the form of list.
![1]: https://i.stack.imgur.com/3yoHL.png
Note:'Query1' is dynamically changes as we change the parameter.
Solved! Go to Solution.
@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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |