Forum Discussion
Missing a few records when using Data with Current Layout function
Hi
I have got the total records of 1593. I then used the Data with Current Layout function to export the data (table visual) to excel, the excel shows 1585. There are 8 records missing. To note, the data is published and I use the Export Data function to export the table.
I wonder why missing data. I assumed that it should be the same amount.
Kind regards,
Anna
Hi, Anonymous
If you have duplicates in the original data, the same rows will be aggregated in the table, which will result in less data; you can add an index column (unique flag column) to the table.
No Index column:
Raw data:Publish and export data:
Add index:
Publish and export data:
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
1 Reply
Hi, Anonymous
If you have duplicates in the original data, the same rows will be aggregated in the table, which will result in less data; you can add an index column (unique flag column) to the table.
No Index column:
Raw data:Publish and export data:
Add index:
Publish and export data:
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum