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.
Hi all,
I've had a look at other threads but I'm still having issues with duplicates remaining in my data after "Removing Duplicates" in PowerQuery editor. I've tried:
But still, my lookupvalue fails due to muliple values. When I export the data into excel and highlight duplicates, I can see the values causing issues:
Any ideas on what to try next? I can filter them out manually and then everything works so they are definitely causing the issues.
Solved! Go to Solution.
Hi @AlexJ01 ,
In Power Query, before your Remove Duplicates step, select the [Part Number] column and go to:
Transform tab > Format (dropdown) > Trim.
Pete
Proud to be a Datanaut!
Hi @AlexJ01 ,
In Power Query, before your Remove Duplicates step, select the [Part Number] column and go to:
Transform tab > Format (dropdown) > Trim.
Pete
Proud to be a Datanaut!
Check out the July 2025 Power BI update to learn about new features.