Persistent Refresh Failures in Power BI Service

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>"}