Why do I get this error when refreshing Dataflows?

[Anonymous]

I made a dataflows (PostgreSQL Database)

'get data' 34 tables, but there was a error when refreshing..

Error message is:

Error: Encountered user gateway exception: '[DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=PostgreSQL [Microsoft.Data.Mashup.ValueError.DataSourcePath]=Server;DB [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException An error happened while reading data from the provider: 'I/O error occurred.' [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=3097292]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=3097292]'. RootActivityId = d705c0cc-88b8-4d11-a592-235bb5e94927.Param1 = [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=PostgreSQL [Microsoft.Data.Mashup.ValueError.DataSourcePath]=Server;DB [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException An error happened while reading data from the provider: 'I/O error occurred.' [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=3097292]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=3097292] 

[Anonymous]

I made a dataflows (PostgreSQL Database)

'get data' 34 tables, but there was a error when refreshing..

Error message is:

Error: Encountered user gateway exception: '[DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=PostgreSQL [Microsoft.Data.Mashup.ValueError.DataSourcePath]=Server;DB [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException An error happened while reading data from the provider: 'I/O error occurred.' [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=3097292]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=3097292]'. RootActivityId = d705c0cc-88b8-4d11-a592-235bb5e94927.Param1 = [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=PostgreSQL [Microsoft.Data.Mashup.ValueError.DataSourcePath]=Server;DB [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException An error happened while reading data from the provider: 'I/O error occurred.' [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=3097292]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=3097292] 

[BA_Pete]

Hi @Anonymous ,

I can't be sure as no one here really reads 'error log', but my first guess would be an issue with your Gateway.

First things I'd check:

- Enterprise Gateway is running and functioning correctly when refreshing other sources (network, on-prem SQL etc.)

- PBI Desktop file is using the correct data connector

- Power BI Desktop is updated beyond December 2019 release (NpgSQL 4.0.10 shipped with PBID from this release onward)

- Enterprise Gateway is not installed with a Postgre connector beyond NpgSQL 4.0.10 (NpgSQL 4.1 and later versions aren't compatible with .NET)

Pete