Connection to supavisor closed by server after 40 seconds

I am attempting to retrieve a large amount of data from my database. However, I am encountering an issue where the transaction is being closed by the server after approximately 40 seconds every time I use a supavisor connection. I have already checked that the Postgres timeout for statements is set to 2 minutes. I am currently using 'Transaction' mode in Pooler. Could this be causing the issue?