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

bcampos's avatar
bcampos
Frequent Visitor
1 year ago

Hi dharmendars007  I have tried to achieve this by clearing global data source settings and that has not resolved the issue. Do you have any other suggestions?

 

Thank you!

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