Persistent Refresh Failures in Power BI Service

[Developer_user]

We have been experiencing a persistent issue with our Power BI Service for the past few months, and despite our efforts to resolve it using various solutions available online, we have been unable to achieve a resolution.

Issue: Every day, a few reports in our Power BI Service are encountering refresh failures with the following error message: "The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support"

error json:

error": 
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
"pbi.error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
"parameters": {}

"detail": {
"type": 1,
"value": "<ccon>ODBC: ERROR [08S01] server closed the connection unexpectedly\n\tThis probably means the server terminated abnormally\n\tbefore or while processing the request.\n;\nThe connection has been lost</ccon>"}

[Anonymous]

Hi  @Developer_user 

So what are the data sources corresponding to these reports ? Can these reports  be refreshed normally before?

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Developer_user]

Yes, it was refreshing in the past, but we have been experiencing this issue for the past few months.

We are only using Postgres as a data source.