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 UserFrankByl by now you already learned that you need to create a unique row. To add a unique value aka index column, following these steps:
- transform data -> add columns -> index column. It will add a new column called Index, rename it whatever you feel like.
As you drop this column on the visual, to hide it, use the new feature to set the custom width of the index column to zero. Read more about this here Matrix visual format settings in Power BI - Power BI | Microsoft Learn
Thanks Parry 2k
In my original post I mentioned that we "In Power BI we added an Index column which we call the UniqueID hoping that would uniquely identify the two rows. Did not work. We made a measure column which was the Index Column * 1 and called it AllowDuplicateID and neither the UniqueID or the AllowDuplicateID show up in the Excel table or Excel Pivot Table. "
It didn't work. Am I missing something in your notes?
Right now we are asking the software support to include a time stamp in each journal entry and hope that will make it unique enough to stick when we do the sync from PowerBI to Excel.