Failure to Refresh

[AlRuss]

Hi All, 

None of my reports are refreshing due to an error in my DimGeography Table. I have checked the model in PowerQuery and I don't know how there could be a duplicate value as I uppercase text everything, and then remove duplicate values. How could there still be a duplicate?

Data source error: Column '<oii>Postal Code</oii>' in Table '<oii>DimGeography</oii>' contains a duplicate value 'KT13' 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. Table: DimGeography.
Cluster URI: WABI-US-EAST2-D-PRIMARY-redirect.analysis.windows.net
Activity ID: b37fb37f-597e-d324-5d2c-2985de2e7add
Request ID: 3b059ca7-20f1-4954-35e7-144975505d29
Time: 2025-04-11 14:11:30Z

[ibarrau · Accepted solution]

Hi. Sometimes the nulls or blanks produces issues at relationships similar to the duplicates. Make sure you can see any of them. Open Power Query Editor. Click on the column that makes the relationship. Then use the operation "Keep Duplicates". If the table is empty and can't find one, then remove the step and look for nulls or blanks. Consider that errors will be translated as nulls, so if you have 2 errors it can be a duplicate.

Whie spaces can be a problem too. You can Clean and Trim the column if the data type is text. Do this before keeping duplicates.

I hope that helps,

[AlRuss]

Thank you! Someone put data ending in space, which was not caught when duplicates were removed, but was similar enough that my relationship was broken.