Merge Column from Folder Connector Query is Slowing Down PQ Performance

Hi dbalkin777 ,
Thanks for Jonvoge reply.
You can try to reduce the table size by filtering out unnecessary rows before merging. Next, create indexes on the columns you want to merge. This can help Power Query perform merge operations more efficiently. Of course, you also need to make sure that the data types of the columns you want to merge are consistent. Mismatched data types can slow down the merge process.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly