Forum Discussion

bcampos's avatar
bcampos
Frequent Visitor
1 year ago
Solved

Message=Exception while reading from stream, ErrorCode=-2147467 when connecting to a PostgreSQL view

I've been having issues when connecting/ refreshing a specific postgreSQL view in power query editor. I have another view in the same file and that seems to refresh and load without any issues. T...
Need Help
  • bcampos's avatar
    bcampos
    1 year ago

    Hi Wenbin,

    I did try adding a timeout but that didn't help unfortunately. However changing the view to a materialised view and getting the data as a query has worked!

     

    Thanks,

    B

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi dharmendars007, thanks for the quick reply, I'll add more.

Hi bcampos ,

Regarding your question, you mentioned that the CPU usage is very high. Is it because of a timeout during reading? Set the timeout here to see if it helps.

According to this post, you can also check whether it is a firewall problem.

Solved: Postgresql: Exception while reading from stream - Microsoft Fabric Community

 

Best Regards,
Wenbin Zhou

bcampos's avatar
bcampos
Frequent Visitor
1 year ago

Hi Wenbin,

I did try adding a timeout but that didn't help unfortunately. However changing the view to a materialised view and getting the data as a query has worked!

 

Thanks,

B