Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey,
I need to pass a list as a filter argument in query editor to multiple tables. I have a list of Survey Ids in an excel file and I need to pass that list to multiple tables in query editor.
I've tried this but I cannot get it to work.
Thanks!
Solved! Go to Solution.
Import the List.
Use a Merge each query with this using an inner join and it will remove items not in the list.
Import the List.
Use a Merge each query with this using an inner join and it will remove items not in the list.
Worked! Thank you!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |