Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Advocate V
Advocate V

Export to excel doesn't export all records

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?

Community Support
Community Support

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.


Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

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.




Community Champion
Community Champion


dont you have any aggregations in the fields in visual pane?

do not hesitate to give a kudo to useful posts and mark solutions as solution

Hi @az38,


No. No aggregations are done on the datasets.




Super User
Super User

HI @vidyadutt ,


Are there any filters on your report before exporting data?




Best Regards,

Pragati Jain

MVP logo

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi @Pragati11 


No, no filters were applied when I exported the data.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.