Forum Discussion
Rows getting merged if duplicates exist in source data
I have a data source that has 5 rows. There are two pairs of duplicates in the source data but PowerBI treats them as a single row - likely because there is no unique identifier for them. I've added a Row Number column to give them a primary key, but unforunately this report needs to be exported into a specific format for software ingestion, and cannot contain the RowNum column.
Below is the 'merged' table.
Below is the table with rowNum included, showing all necesarry rows.
Below is what occurs when you sum this column, as you can see it is summing correctly.
Does anyone have any insight on how I can get PowerBI to not merge these rows? I am not summing any other columns. Is there a way to hide the RowNum column from the table, yet still include it's effect of acting as a primary key?
Thank you!
2 Replies
- Padycosmos
Solution Sage
Hope this video helps:
- AnonymousNot applicable
Thanks for the reply
Unfortunately the data hidden like that will still show up in the csv export.