Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
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.
User | Count |
---|---|
23 | |
18 | |
16 | |
13 | |
11 |