Forum Discussion
Improving/alternative inner join query
I have 2 tables, one with 20k rows and another with 5m I only want to load the rows that match in both tables Somehow this is seeming impossible, the preview doesnt even stop loading so I can...
One of your transforms broke query folding so now Power Query has to load both tables completely before doing the join.
The alternative is to let the data model do the work for you. Do it in Power BI instead of in Power Query.