Exporting Mega Tables
Do Mega Tables usually tell you if your export is missing data? I have a mega table with 100,000 rows but when I export, it gives me 50,000 but there is no error message saying it did not export all data.
**If this answer solved your problem be sure to like it and accept it as a solution!
Best Answer
-
@Ashleigh
The limits for exporting from Mega Table to Excel are listed in this KB article:
"When exporting to Excel, only data that is displayed in the Card will be exported, up to 1M cells of data while exporting to CSV will output all rows. For Megatables, Pivot tables, and HTML tables, this is 50k rows by default and up to 100k rows by manually increasing the row limit inside of Analyzer."
Your Analyzer will likely say "All Rows", but if you change it to 100,000 then you will get 100,000 rows in your Excel export.
I hope this helps!2
Answers
-
I believe it is a limitation with the Excel option when choosing Send/Export. I just tested with an mega table card that had 84k rows. When I chose Excel, it only exported 50k rows. When I chose CSV, I got all 84k rows.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
It does seem like this should be something that you are warned about prior to exporting. Did you want to post this in the Ideas Exchange @Ashleigh ?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
@ST_-Superman-_ yea I can post it there, I just wanted to double check it wasn't an error on my end because I've seen an excel report give an error before but I think it may have been for a pivot table export.
**If this answer solved your problem be sure to like it and accept it as a solution!
0 -
@Ashleigh
The limits for exporting from Mega Table to Excel are listed in this KB article:
"When exporting to Excel, only data that is displayed in the Card will be exported, up to 1M cells of data while exporting to CSV will output all rows. For Megatables, Pivot tables, and HTML tables, this is 50k rows by default and up to 100k rows by manually increasing the row limit inside of Analyzer."
Your Analyzer will likely say "All Rows", but if you change it to 100,000 then you will get 100,000 rows in your Excel export.
I hope this helps!2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive