Refresh Report Is failing in PowerBI when processing from Amazon RDS PostgresQL

Question

I have a Power BI Premium plan and an RDS PostgreSQL instance running on AWS. Additionally, I have an EC2 server hosting a Power BI instance. We have connected Power BI to the RDS PostgreSQL through this EC2 instance and use an On-Premises Data Gateway to fetch and publish data. We are publishing this using power BI apps.

However, when attempting to publish a dataset containing 60 GB of data, I encounter the following

There was an error when processing the data in the dataset. Hide details
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeli
ne_Gateway_Mashup DataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_Un
derlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_Unde
rlyingErrorMessage","detail":{"type":1,"value":"PostgreSQL: Exception while reading from stream"}},{"co
de":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"cod e":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mash
up.ValueError.DataSourceKind","detail":{"type":1,"value":"PostgreSQL"}},{"code":"Microsoft.Data.Mashu
Cluster URI:
p.ValueError.DataSourcePath","detail":{"type":1,"value":"here is my database endpoint"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":
1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"valu
e":"Exception while reading from stream"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail": {"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Items. WABI-US-NORTH-CENTRAL-C-PRIMARY-redirect.analysis.windows.net
56154d44-c1e9-4f7e-8f4e-96e82e244f37
Activity ID:
Request ID:
Time:
2025-03-04 09:55:04Z
41fc273d-c98f-73a4-c7f3-e86f3f3d64af

Can anyone please help me understand why this job is failing? Interestingly, it occasionally runs successfully.

Thank you in advance for your assistance!