duplicate

[descalabro]

Hello,

I have created queries to remove duplicated values from an appended table. In the query editor the duplicated values disappear, but on the data view and on the report view the duplicated values are still present in the tables and in the graphics.

Refreshing only reloads all the vlues.

Restarting the program runs the queries, but still they seem to only have effect on the query view.

Thanks for any help,

Tiago J

[Ahmedx]

if i understood you correctly it looks like you have spaces at the end of the line, in power query it is not a duplicate but in power bi it will be a duplicate
you need to clear the column from spaces and then delete the duplicate