Forum Discussion

dbalkin777's avatar
dbalkin777
Frequent Visitor
1 year ago
Solved

Merge Column from Folder Connector Query is Slowing Down PQ Performance

Greetings. One of my data sources is seval excel files combined using the folder connector (i.e., sample file --> final query with all excel files appended). Performance is fine in that final query, ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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