Forum Discussion
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...
I have the same intermittent problem refreshing multiple datasets with PostgreSQL in AWS. Did you get closer to a solution ?
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...