Live connection always tales time.
So using extracted data source with auto refresh should be alternative.
But to get extracted data source in server, you should publish the data source itself to server beforehand.
Live connection to database.
Filter datasource to reduce the size
Set refresh schedule on datasource
--On workbook on server--
Connect to new datasource (above data source on server)