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

dharmendars007's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
1 year ago

Hello bcampos , 

 

One solution I can think of is go to global Data source settings and remove the source which was connected before and re-connect this should hopefully resolve the issue of refersh.

 

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

 

Thank You

Dharmendar S

LinkedIN