External Database Connection for Dashboard - Data Volume Restriction

We don't normally recommend using OneStream as a repository for downloading huge amounts of data to the clients.
The grid view components aren't really optimized for large amounts of rows.
In this case, I would consider using the embedded spreadsheet and a TableView. There should be an example BR on the Golfstream application. This way you get a dump of data directly into a native spreadsheet layout that you can instantly save as an offline Excel workbook.   I would avoid exporting dashboard components to CSV because you get date and number formatting issues, especially where user's MSOffice regional settings can vary.