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...
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.