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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AndrewHam
Helper I
Helper I

Merge Query Issues

hi

I encountered a strange issue when trying to merge 2 tables,

In both tables, i have 2 columns named Order and Objet. However, when I use Merge outer, I was given 0 matches. But when i use lookupvalue, I am able to find matches. Why is that so ?

1 ACCEPTED SOLUTION
AndrewHam
Helper I
Helper I

hi all,

I have finally managed to solve the problem by using the trim on both tables.

Thanks for all the guide provided.

 

 

View solution in original post

3 REPLIES 3
AndrewHam
Helper I
Helper I

hi all,

I have finally managed to solve the problem by using the trim on both tables.

Thanks for all the guide provided.

 

 

v-jingzhang
Community Support
Community Support

Hi @AndrewHam 

 

Can you show some sample data or screenshots of the problem?

 

My guess is that the case of the data in the two tables may be different. In Power Query Editor, it is case sensitive so it gives you 0 matches if data has different cases. However, after you load data into Power BI Desktop, it is case insensitive in the data model. So it will treat them as the same data when using lookupvalue. In this situation, if you want to use Merge queries feature, you can add a step to upper or lower the case of the two columns to make them identical in both tables, then do the merging. 

 

In addition, if you select two columns as the matching columns, ensure that you select them in the same order in two queries. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

mussaenda
Super User
Super User

Hi @AndrewHam 

 

to help you better,

Provide a sample data where we can copy and the desired output and the screenshot of what you are encountering.

 

Thanks

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors