Out of memory while reading tuples; memory allocation error

[JasonC_XBI]

I have been attempting to connect to RNA central (https://rnacentral.org/help/public-database), a public access PostgeSQL database using Power BI.
I have been attempting to connect using the psqlODBC driver, configured to the settings listed on the public database page.
The challenge I am encountering is that after selecting the tables I wish to explore, the data fetch times out with the following error:
Out of memory while reading tuples; memory allocation error
Does anyone know what might be causing this error?
Any advice you can offer would be most appreciated.

[HotChilli]

Online sources suggest a postgres/odbc configuration change could solve this.

Have you tried altering the 'Use Declare/Fetch' option under DataSource in ODBC setup?  If I understand the option correctly, it implements a cursor which returns data in smallish batches rather than one enormous batch

[harvelino]

Thank you.