Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to export data from a table visual, which has 8000+ records, however the exported excel (and also csv) has only 2000+ records.
Then I added an index column (Edit Query --> Add Column --> Index Column --> From 1), and added the index column to the table visual. After that when I export to excel, I get all records in excel (also in csv).
The problem exist in both Desktop and Service.
Anyone experienced this issue and know any solution?
Hi @vidyadutt ,
Index column means every row is unique. So you could check if you have the same rows. And check every column is not summarized.
Hi @v-eachen-msft,
The rows are not the same, there are no duplicates. And I'm not summarising columns either. The problem is when I export I don't get the same data that I see in the report.
Regards,
Vidyadutt
dont you have any aggregations in the fields in visual pane?
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |