Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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.
What kind of join/merge are you using, and what are you actually joining?
--Nate
@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.
Hi @Anonymous ,
In Table 2, add a custom column and add the code below:
Regards
KT
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.
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:
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Check out the July 2025 Power BI update to learn about new features.