Limit Text Table in dashboard but export for full table

I have a text table on my dashboard that I have to limit to 500 rows (using index()) to improve performance. However, my users need to export this table after drilling down into the data they need using dashboard actions and/or global filters. Is it possible to have the export be the full data instead of limiting it to 500?