Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Findex-Jimmy

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

Submitted by on ‎01-31-2023 10:31 PM

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. 

Gateway fail.PNG

 

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎02-01-2023 11:38 PM

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

Idea Statuses