I've dealt with this too. Right now, scheduled reports from Workspace only send the top 50 rows per panel, so if you’re working with large sets of data, it’s not ideal.
The “Download items as CSV” option is still the only way to get everything straight out of Workspace, but yeah—it’s manual.
If you ...