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 psqlODB...
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.