Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Merge Queries - fastest method

Hello,    I'am doing a merge querie but takes a long time, i want to know if there is another way, more faster to do this process.   Thanks a lot!
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    1.In the Table 1, select the Merge Queries.

     

    2.Select the Cod column in both tables, and then click OK.

     

    3.Expand the column.

     

     

    Best Regards,

    Stephen Tao

     

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

     

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi Anonymous ,

 

My initial thought was, if you are having performance issues with a merge in Power Query just push the merge to the source if that is possible? If you cannot out of some reason, then I recommend this blog series by Christ Webb:

 

Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 1: Removing Columns Chris Webb's BI Blog (crossjoin.co.uk)

 

Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 2: Does When You Remove Columns Matter? Chris Webb's BI Blog (crossjoin.co.uk)

 

Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge Chris Webb's BI Blog (crossjoin.co.uk)

 

Let me know if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello, tackytechtom 

 

How can I push the merge to the source?

 

Can you help me?

 

thanks a lot.