Export data to Excel

[Sebastian_Palacio_Re]

Hello. I have a table in quicksight with 121.000 rows and I want to export it to Excel. When I export it, it download only 30.000 rows.
How can I export the complete table? Is there an option where I can configure the amount the rows I wanna export?

Thanks for your help

[sagmukhe]

@Sebastian_Palacio_Re - Please see the below documentation link and excerpt. You should be able to export. Did you check if you are reaching that 500MB threshold as mentioned in the following link? Hope this helps!

Exporting data from visuals - Amazon QuickSight

[Sebastian_Palacio_Re]

Hi sagmukhe! Yes, I checked that and the file reaches 3.65MB. I’m attaching the image

I do not know what to do in this case.

[sagmukhe]

@Sebastian_Palacio_Re - Thank you for your feedback. In that case, I don’t have other ideas or thoughts. I am tagging few QuickSight Team members who perhaps can help you. Also, you can perhaps explore the option to open a Support ticket. Hope this helps! Thank you!

• @gillepa @EnriqueS @Koushik_Muthanna @Kellie_Burton @Wakana @royyung

[Sebastian_Palacio_Re]

Thanks @sagmukhe for your help! Ok so let’s wait for the answer from the team, otherwise I can talk to AWS support!

[royyung]

can you check if the data was aggregated in the table?

[Koushik_Muthanna]

hi @Sebastian_Palacio_Re ,

The excel limit is 100k or 16,384 columns. So depending upon the number of columns and rows you have in your table , the final number of rows exported can be lesser.

Export details when downloading

With 2 dimensions and 1 measure [100k records exported]

With 11 dimensions and 1 measure [80k records exported]

Kind regards,
Koushik

[Sebastian_Palacio_Re]

@royyung No, I have not checked it! I am going to talk to the user if he has the data agg.!

I’ll tell you soon

Thanks for your help

[Sebastian_Palacio_Re]

@Koushik_Muthanna Let me validate with the user this info and I’ll tell you later the answer

Thanks for your help