Forum Discussion
Failure to Refresh
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,
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,
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.
