Forum Discussion

simmi21's avatar
simmi21
Frequent Visitor
5 years ago

Load from Postgres dropping after few minute

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      simmi21
      Frequent Visitor

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

  • mfurgiuele's avatar
    mfurgiuele
    Regular Visitor

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