Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is the table i need to lookup from and bring back the asset group but it stops once it has found Corrugator
Solved! Go to Solution.
Power Query is case-sensitive. Doesn't that explain this?
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
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
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?
Power Query is case-sensitive. Doesn't that explain this?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
9 | |
8 | |
7 | |
7 |