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.
Very new to Power Query. I want to perform a Vlookup from another workbook.
I saw an old post with a YouTube Link about Merging Queries. But, I can't seem to get it to work.
I have 2 Queries that will be Appended:
I tried to Merge the "Append1" with the "VLookup_Combined", but no matches were found. I know this is incorrect, because I can do a manual VLookup (outside of Power Query), and it works.
What should I be changing?
Can I do this on an Append Table? Or do I need to perform the Merge on each query, before I Append them?
Here are all the files I'm using:
Thanks!
Solved! Go to Solution.
@Anonymous ,
Have you tried cleaning both columns with trim/upper|lower function ?
Power Query is case sensitive and blank spaces in the beginning/end matters for merge.
@Anonymous ,
UPPER -> transform all the text to UPPER CASE
LOWER -> transform all the text to LOWER CASE
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference
Aha - That did it! Thank you, had no idea there was a trim option!
For my learning purposes, what is the upper/lower function please?
Check out the July 2025 Power BI update to learn about new features.