Forum Discussion
Out of memory while reading tuples; memory allocation error
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.
2 Replies
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
Thank you.
