Forum Discussion
filter on multiple values using parameter, in the query editor
I only created a query with de values that I want to filter, then I merged with the principal table for the colum I want to filter, after in the new column I filtered values distinct to blank
The problem with Merge solution is that it does not FOLD to the server; the way that the Power Query engine pushes the heavy-lifting of a query back to a data source/server (search for Chris Webb's BI Blog 'How To Tell Whether Query Folding Is Taking Place When Importing Data From Analysis Services In Power BI And Excel Power Query'). This means that powerbi will do (as far as I understand it):
1) Look a the statements, and if table is more that something like 4000 rows, say "oh dear I can't figure this out, let me download it first".
2) download the whole table (problem is; that could be a few milion rows.
3) Look at the merge statement and then apply the 'matching' (joining if you will).
Result of merge: 15 mins waiting (or longer obviously) and millions of rows downloaded, but only keeping some of them (the ones you merged with) after mashup data is dumped and loaded to the model.
The frustrating thing is: SQL can do this easily with an IN statement. Mashup seems to struggle 😞