Forum Discussion
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...
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
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!
FYI for anyone who comes across this issue in the future, changing the postgreSQL view to a materialised view has worked as a solution