Forum Discussion
Filter table based on another table
Just want to ask something. I have 2 tables in Powe BI. One contains a data set of 13 million rows and the other table contains one columb with the list of values I want to filter in the main table. I...
FYI you can also do this at the Power Query level, by doing a Merge as New and using Inner Join
Is one of these methods faster or more efficent than the other?
If you filter in PowerQuery, then you avoid loading all the "useless" date to the model.