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.
Thanks for the insight Shai. I haven't tried it yet since I don't fully understand. You mentioned "Make sure UniqueID is a calculated column or a Power Query column, then drag it onto the table visual itself". We used the Add Column option and chose the "Index Column". Your saying it should be a calculated column or a Power Query column. I don't understand. Also, since we are not using any visual I don't know how I should be connecting this to the data.
I feel like you are on the right track but I just don't fully grasp the how to do it. I like the tip that I can right click on the column to say don't Summarize. I think that might be the ticket right there.
Any clarifications would help.
Frank