Datasource refresh issue: desktop app works fine, online gateway doesn't

[EH-B]

Hi All,

My PowerBI desktop app refreshes fine via a Putty SSH tunnel to a remote PostgreSQL DB , but when I refresh online I get this error below. Consequentially, Scheduled Refresh doesn't work either.

Could anyone decipher the below error message for me?

N.b. PostgresSQL and localhost:2222;xxxx are the same source.

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"PostgreSQL: Exception while reading from stream"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"PostgreSQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"localhost:2222;xxxx"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Exception while reading from stream"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}

Kind regards,

E

[v-luwang-msft]

Hi @EH-B ，

 In case you have not checked these, please refer. I always check all the settings mentioned

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
https://niftit.com/connecting-power-bi-to-postgresql/

And similar error code refer:

https://community.powerbi.com/t5/Desktop/Postgresql-Exception-while-reading-from-stream/m-p/231070 

Best Regards

Lucien