Dataflow Refresh issue [PostgreSQL: Exception while reading from stream]

[Findex-Jimmy]

Hi Team,

We are in the middle of migrating our Gateway to a new server and we've come up on an interesting issue.

We're getting a 'PostgreSQL: Exception while reading from stream' exactly at 5:15 almost everytime. 

While creating the dataflow, we are able to see the tables within the query so we know it's not a credentail problem. Plus it has succeeded before at random times, despite us not changing anything. 

We've copied all the M-query across into the new dataflow, the old one is still works and is running while connected to the old gateway. 

 

[v-xiaoyan-msft]

Hi @Findex-Jimmy ,

Could you try adding Command Timeout to the M query and test it out? Bump the time out to 20min or 30min.

PostgreSQL.Database - PowerQuery M | Microsoft Docs

You may test it in Power BI Desktop.

I wonder if you can  check on the PostgreSQL DB by running SQL Profiler to see how long are the queries taking ?

Best regards.
Community Support Team_ Caitlyn