Forum Discussion
How to stop PowerBI from automatically removing duplicates.
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.
Super UserPower BI's table and pivot visuals collapse rows that look identical across the fields placed in the visual, so adding an Index column to the underlying model alone does not change anything.
The Index has to be a real column, not a measure. A measure like Index Column * 1 gets aggregated on export so it cannot disambiguate rows. Make sure UniqueID is a calculated column or a Power Query column, then drag it onto the table visual itself and set it to Don't summarize (right-click the field in the visual). Each row will then appear as a separate line and will export that way.
If you are using Analyze in Excel, do the same thing in the PivotTable by putting UniqueID on Rows. Otherwise, from the visual menu use Export data > Underlying data, which skips summarization entirely.
If this helped, please give a thumbs up and mark it as the accepted solution.
Thanks,
Shai Karmani