Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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, ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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