Scheduling refresh against a PostgresSQL database source failing

Hi all, I am getting an error when tyring to schedule a refresh for a PostgresSQL database. In Desktop I have no issues in refreshing but in the Service I am getting these errors:

1) When trying to create an on premises connection
'Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue. '

2) When I am scheduled a refresh using a cloud connection, it fails druing the refresh process:

'DataSource.Error: PostgreSQL: Exception while reading from stream. Microsoft.Data.Mashup.ErrorCode = 10478. Microsoft.Data.Mashup.ValueError.DataSourceKind = PostgreSQL. DataSourcePath = postgndcd1mandash03.postgres.database.azure.com;datalake. Message = Exception while reading from stream. Microsoft.Data.Mashup.ValueError.ErrorCode = -2147467259. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.  '

I am using the same credentials in both Service and Desktop, so does anyone have any ideas on why it is failing both ways? Thanks