Forum Discussion

zenisekd's avatar
zenisekd
Icon for Super User rankSuper 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
Icon for Super User rankSuper User
5 years ago

Could be query timeout issues but my money is on an overloaded PostgreSQL server.  In your Power BI file, disallow parallel loading of tables and see if that improves reliability (at the expense of speed).

zenisekd's avatar
zenisekd
Icon for Super User rankSuper User
5 years ago

Timeout set to 90 minutes, didnt help. Now I am testing your slow solution...

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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 ?