Forum Discussion
Duplicate data
I’ve loaded a .txt file into PBI and am getting duplicates in what should be a column of unique values. These don’t appear in the source and when I load the same data into Tableau this doesn’t happen...
DHB I doubt PBI would be duplicating something in the process of import (never experienced it before). Can you double-check the source. Also via query editor in power bi desktop you can remove rows that are duplicates.
Thank you for your reply. I'm using the same source in both PBI and Tableau but Tableau doesn't have the same problem. Unfortunately I can't delete the dupicate as I would lose the data for the row which should end in 100 (id). What I need is for PBI to give that row the correct id value (....100) instead of ....96.
