Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Attempting to use Merge for a VLookup in Power Query

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:

Capture.JPG

 

 

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.

Capture2.JPG

 

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:

OneDrive_PowerQuery 

 

Thanks!

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

@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.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

3 REPLIES 3
camargos88
Community Champion
Community Champion

@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



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



camargos88
Community Champion
Community Champion

@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.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Anonymous
Not applicable

@camargos88 

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?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.