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 of complex calculations in DAX, in order to get a ABC-XYZ analysis.
Everything eventually worked fine. I managed to upload the file and refresh it.
Now here comes the problem: Once I schedule a refresh, it works only about 30% of the time.
Giving me an error: PostgreSQL: Exception while reading from stream.
To me, the puzzle is, that another dataset (with just a few tables) from the same source works fine every time.
Any suggestions what should I do?
I have read something about setting up Timeout, however I am not sure why would it be sometimes working and sometimes not...
Thanks in advance for your advice.
7 Replies
After some communication with MS support, I have learned that the exception is:
Microsoft.PowerBI.Common.PowerBIModelRefreshFailedDueToUserErrorException: Data refresh failed due to an error in the data processing engine due to user.
Error ErrorCode="3242524690" Description="{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"PostgreSQL: Exception while reading from stream"}}],"exceptionCulprit":1}}}" Source="Microsoft SQL Server 2014 Analysis Services" HelpFile=""
They will further investigate it.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).
