Forum Discussion
Optimizing Filtering in Power Query: Large Datasets with 6M+ Loans and 20M+ Balances
Hello there! Imagine I have two table in Power Query Editor: Loans, with LoanId, BusinessSegment columns. This table contains over 6 mln rows with unique LoanIds. LoanBalances with LoanId, Year...
Merge is doing everything good, just it is too slow and I have to wait sometimes more then 30-40 minute to complete this process.
I hope there is easier way to do this, using M code, but if there is not, okay, I will continuous to merge my queries.