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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Julier
Helper II
Helper II

Power Query merge Issues

I am merging from 2 tables however the merge only brings through the first find and then stops, i have trimmed and cleaned the data and check that it is nt hte capitals that is stoppping it from working  on both tables and checked in excel that the data is the same.

This is the table with the merge as you can see it has stopped after it has found the first set of data

Julier_0-1717408685923.png

This is the table i need to lookup from and bring back the asset group but it stops once it has found Corrugator

Julier_1-1717408775651.png

2 ACCEPTED SOLUTIONS
HotChilli
Super User
Super User

Power Query is case-sensitive.  Doesn't that explain this?

View solution in original post

Thanks for this, the case sensitive did work, the problem was that the 2 tables had a mixture of upper and lowercase rows, once i had amended the two files to read the same it worked

View solution in original post

4 REPLIES 4
HotChilli
Super User
Super User

OK, you have all the tools to investigate this.

Try a Group By and see if the suspected same entries are shown in 2 groups.

OR

remove all the entries apart from the suspected non-matching entries. Look at the Column quality, distribution and profile features.

OR

remove all the text apart from the first 3 characters. Do the merge. See if it works. If it does, use 4 characters to merge, repeat until it breaks.

Thanks for this, the case sensitive did work, the problem was that the 2 tables had a mixture of upper and lowercase rows, once i had amended the two files to read the same it worked

Julier
Helper II
Helper II

thank you but no it doesnt, i have changed the Site ID_Asset ID to uppercase and it still does not pull the data through?

HotChilli
Super User
Super User

Power Query is case-sensitive.  Doesn't that explain this?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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