Rows values are not combining for similar values

[Anonymous]

I'm trying to figure out why the same values are not combining when I put it into a table or matrix these values are repeating. I've tried searching for a similar problem, but I've been unable to find a case related to values repeating in rows. Has anyone seen this before?

[amitchandak]

@Anonymous ,Strange. Can you share a sample pbix after removing sensitive data.

[Anonymous · Accepted solution]

I was able to resolve the issue. I'm still not sure what the underlying cause was, but I deleted the dataset and created it again using the same Advanced Query. The duplication issue went away after recreating it. I appreciate your help.

[amitchandak]

@Anonymous , I doubt some special character or space.

Refer this remove all other characters : Leave the excel part, check power query part -https://xlncad.com/remove-or-extract-special-characters-from-a-data-set-using-power-query/

Also use text.trim to remove any additional space

https://docs.microsoft.com/en-us/powerquery-m/text-trim

and then try

[Anonymous]

This was my first thought as well. I've tried trimming the data as well as cleaning the data and neither resolved the issue. This field is based off a database field and doesn't contain any special characters or spaces. In the datasource itself Power BI and SQL display only the unique values and combines them correctly. It only duplicates when I put them in a table/matrix.