Load from Postgres dropping after few minute

[simmi21]

Hi, 

I have a Postgress DB source (running on AWS), which I am trying to connect my Power BI Desktop to.

I am able to establish a connection but when pulling data from one of the table (which is quite big in size, approx 30 Milion records and in future it would grow further) it initially start the data extraction but giving below error after a while -

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] PostgreSQL: Exception while reading from stream. '.

What I am finding strange is that it's not reaching any capacity limit of Power BI (Import Mode) before it is getting terminated. just after few30K records, it throws this error. Even in the task manager it is not hitting any memory limit. Also I am not doing any transformation on the query editor. It's the basic 2 step in Query Editor window (Source & Navigation) (At the backend I assume it is just running select * query)

I had tried to increase the command timeout parameter in the M query to 1hr as well (as last time hwen I had worked with this table it had took approx 40 mins to pull the records)

I would really appreciate if you can tell what is the root cause of this issue and how can I resolve this

[mfurgiuele]

I have the exact same issue. Did you happen to figure out the solution to this error?

[Anonymous]

@simmi21 

Try clear cache, and increate the Maximum cached of Power bi desktop. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[simmi21]

Hi, No clearing the cache didn't help ;(