To export more than 500 reports:
- Display the report in Analytics
- Append &limit=50000 at the end of the URL in your location bar BEFORE any hash (#) sign. You may not have a hash sign in your URL.
- It would seem nothing happens because Analytics continues to show 500 rows. But when you Export CSV, Analytics will export more than 500 rows (upto 50000). Note that I've only tested it on CSV option, not other XML, PDF, CSV for Excel or TSV.
Enjoy your big reports!