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!

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.

Merge Queries - fastest method | Microsoft Fabric Community

6 Replies

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
  Not applicable
  4 years ago
  Hello, tackytechtom
  
  How can I push the merge to the source?
  
  Can you help me?
  
  thanks a lot.
Anonymous
Not applicable
4 years ago
What kind of join/merge are you using, and what are you actually joining?

--Nate
- Anonymous
  Not applicable
  4 years ago
  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.
  - Anonymous
    Not applicable
    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.
    
    Merge Queries - fastest method.pbix27 KB

Forum Discussion

Merge Queries - fastest method

6 Replies

Related content

shortcuts - Refresh Method

Authentication Method for lakehouse

CTE's to Direct Query Method in Power Query

SharePoint Online List Direct Query method

Develop an automated method

Cod	Name
1	Gary
2	Ferdinand
3	Paolla

Cod	color
1	Blue
2	Gray
3	Green