Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Why do I get this error when refreshing Dataflows?

 

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] 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      BA_Pete
      Super User
      4 years ago

      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