Merge Queries - fastest method

[Anonymous]

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!

[Anonymous]

What kind of join/merge are you using, and what are you actually joining?

--Nate

[Anonymous]

@Anonymous 

I try to do a VLOOKUP in a Power Query, but waste a lot of time.

For Example i have table 1: 

Cod	Name
1	Gary
2	Ferdinand
3	Paolla

I try do cross to table 2:

Cod	color
1	Blue
2	Gray
3	Green

I want try to do this more faster.

[KT_Bsmart2gethe]

Hi @Anonymous ,

In Table 2, add a custom column and add the code below:

•  Table.SelectRows(Table1, (x)=> x[Cod]=[Cod])[Name]

Regards

KT

[Anonymous · Accepted solution]

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]

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]

Hello, @tackytechtom 

How can I push the merge to the source?

Can you help me?

thanks a lot.