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.
Hi FrankByl Power BI visuals display only distinct values of a dimension unless the column is configured to be sorted by another column that contains different values for otherwise identical entries, or the visual is grouped by another column. Adding an index column uniquely identifies each row in the table, but it does not automatically distinguish identical entries. If Power BI considers the entries identical, they will not be displayed separately unless a column is introduced that differentiates each occurrence, such as a timestamp, transaction ID, or another unique value.
Hello Danextian,
I'm understanding the prinicple by I don't know how to "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)." I've asked the support of the accounting software to export a time stamp with each journal entry. Hopefully this will provide enough info that PowerBI will stop summarizing what it considers to be duplicate data. I don't know a way to do this with the info that I have. If you have more step by step help for me to do this myself that would be great. It's frustrating that we have created and Index, which is unique, and a unique identifier (Index*1) and it simply refuses to export those columns.