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...
Hi Bhavesh,
Thank you for the advice.
When I put the data into the Query Editor and changed the id column from whole number to text it resolved the issue. The same thing worked for other .txt files that had the same problem. This is good news but it's going to be awkward doing that every time. Can I automate this somehow?
I'll have to get permission to share a file so will let you know asap on that.
Hi DHB,
Unfortunately not, PowerBI selects the best data type suitable for your column automatically but sometimes it may not be the correct data type and you have to manually override that in the query stage.
Hope this has clarified your understanding.