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.