Missing a few records when using Data with Current Layout function

[Anonymous]

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

[Anonymous · Accepted solution]

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 Team

If 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