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...
I agree with Anonymous .
For even more speed you can use the Table.AddJoinColumn function instead because it does not actually bring any data from the joined table.
And JoinKind.LeftSemi could even add a bit more speed.