Forum Discussion

zenisekd's avatar
zenisekd
Super User
5 years ago

Occasional scheduled refresh errors of postgre SQL: PostgreSQL: Exception while reading from stream

Hi everyone,    I have a problem that I can't figure out by myslef... I use Posgre SQL database (on AWS) IMPORT.  I loaded about 30 tables (I use the dataset as a datasilo).  I made a couple o...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

Also talk to the owner of the PostgreSQL server to see if they can do diagnostics on their end, and maybe add an index or two.

zenisekd's avatar
zenisekd
Super User
5 years ago

it runs on AWS... not sure, if there could be an issue.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have the same intermittent problem refreshing multiple datasets with PostgreSQL in AWS. Did you get closer to a solution ?

    • zenisekd's avatar
      zenisekd
      Super User
      5 years ago

      After a lot of digging it turned up, that it was caused by the way I cleaned the tables in Power Query and connected them afterward (I think that there was some duplicity in ID in some table for some strange reason). For some reason, I would work in the desktop and it could be uploaded to Power BI, but when it tried to do a scheduled refresh, it would fail. 

      So my recommendation is to go thoroughly through your Power query steps and model and look for any kind of error when loading the data to your model...