Forum Discussion
Solved
How to stop PowerBI from automatically removing duplicates.
In our data we have some seemingly duplicate values that are not duplicate. They just happen to be identical entries that appear twice on the same day. PowerBI is removing those duplicates when we ...
Thank you everyone for your support. Our eventual fix was to also export the time stamp on each entry. Since some entries were identical in everyway they would always have a unique time stamp since they would be entered separately, if only one minute apart. Once we included the time stamp this was sufficient data to identify unique records and we were able to export ALL records.
Hi FrankByl, as others have suggested here, you must have a unique column in the visual itself.
- Selecting "don't summarize" with a right-click on the column name will not help.
- You don't need the "Sort by another column" feature, it won't help as each text value must have a corresponding single index (not your case)
- So, what you can do is to place both the value you need and the index on the table, then turn off the text wrap for column headers and manually make the index column invisible (note it will still be available when downloading Excel, but not visible in the Power BI report)
See the example attached, and good luck with your project!