cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zenisekd
Helper I
Helper I

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.

 

image.png

 

7 REPLIES 7
zenisekd
Helper I
Helper I

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.

lbendlin
Super User III
Super User III

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).

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

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.

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

hwoe
Regular Visitor

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...

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors