Hello everyone,
In Power BI, we have two identical numbers; the only difference is that one of them has a space/tab at the end. In Power BI, the TRIMMED TEXT function and Remove Duplicates do not seem to help. They delete the duplicate value from Power Query, but it still appears in the report with the error:
Column '<ccon>Material</ccon>' in Table '<ccon>Material</ccon>' contains a duplicate value '<ccon>MNK/USA/NO578949</ccon>' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Can anyone help with what should be done in this case?
Thanks in advance.
My suggestion is to first - remove the relationship before editing in Power Query then after performing the next steps listed, recreate the relationship. Then not only TRIM and Remove Duplicates, but to also CLEAN the data using the following entry make sure the CLEAN and TRIM happens before the removal of duplicates as well:
My suggestion is to first - remove the relationship before editing in Power Query then after performing the next steps listed, recreate the relationship. Then not only TRIM and Remove Duplicates, but to also CLEAN the data using the following entry make sure the CLEAN and TRIM happens before the removal of duplicates as well:
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
