Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I need, in PowerQuery, create a step to filter a by field ( JOB) Table (CGJOBS (2) using a list already created (realocList).
Thanks
Solved! Go to Solution.
You first need to convert your list to table, then use Merge Queries transformation, and select Inner Join as the join type on the two columns
You first need to convert your list to table, then use Merge Queries transformation, and select Inner Join as the join type on the two columns
yes and no... that's not a filter by at query time but a merge. If we want to only keep 10 items out of millions of rows this method would require to first download the 10M rows to then only merge 10.
Filter by list would imply using Table.SelectRows and be able to refer a list of values.
Why didn´t I think that? Sometimes we are so determined to a specific type of solution we became blind.
Thanks
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
63 | |
53 | |
39 | |
25 |
User | Count |
---|---|
85 | |
57 | |
45 | |
43 | |
38 |