SMART Connect 7 query not returning all raw observation data

Hi SMART Community,

We are trying to give an external partner ongoing access to all raw observation data from one CA, via their own restricted SMART Connect user account.

We created a query in SMART Desktop that was intentionally broad: an observation query of all dates, categories and attributes. It returns the full dataset correctly in the Desktop, but does not return all data (not even close) in SMART Connect. We understand that this is a large, structurally complex query, but we specifically need the raw output rather than a reduced/summarised query.

We are currently using SMART 7 and cannot coordinate an upgrade yet as several on-site PCs do not have internet access at present. Would anyone be able to assist us with a workaround that would allow the full raw observation query to run correctly in Connect without upgrading?

Thanks a lot!
Mich