Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
@Anonymous ,Strange. Can you share a sample pbix after removing sensitive data.
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.
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |