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 cant continue the steps I need, and when loading to BI, it takes forever
Is there another way to achieve this results without merging queries?
2 Replies
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.
Hi PowerBITestingG ,
You can try using dax to merge:
NATURALINNERJOIN function (DAX) - DAX | Microsoft Docs
https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/
https://community.powerbi.com/t5/Desktop/Merge-2-tables-with-Power-BI-Desktop/m-p/306945
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
