Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Why do I get this error when refreshing Dataflows?

HUAM_1-1652946245369.png

 

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] 

2 REPLIES 2
Anonymous
Not applicable

HUAM_0-1652941489880.png

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] 

 

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.