Skip to main content
cancel
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.

Reply
vidyadutt
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?

6 REPLIES 6
v-eachen-msft
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.

 

Regards,

Vidyadutt

az38
Community Champion
Community Champion

@vidyadutt 

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
LinkedIn

Hi @az38,

 

No. No aggregations are done on the datasets.

 

Regards,

Vidyadutt

Pragati11
Super User
Super User

HI @vidyadutt ,

 

Are there any filters on your report before exporting data?

 

Thanks,

Pragati

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

Announcements
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

PBI_APRIL_CAROUSEL1

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.