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_ErrorDeta...
Need Help
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