Issue with Automatic Refresh

[Panarba]

I have connected posgres db in powerbi and used on premise gateway to automatic refresh data but getting following error , I need help here

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Please install Npgsql version 4.0.10.0 or earlier."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"PostgreSQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"tma-postgres-instance-1.cyovik8pbkff.ap-south-1.rds.amazonaws.com:5432;TMA"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.MissingClientLibrary"}}],"exceptionCulprit":1}}} Table: public campaigns. Cluster URI: WABI-INDIA-CENTRAL-A-PRIMARY-redirect.analysis.windows.net Activity ID: 90618fcf-77aa-4973-89f6-65c9a5599ec8 Request ID: f4e09ee6-e35c-4511-80d7-dbd0c1eeb58a Time: 2023-08-24 05:46:29Z

[Panarba]

Below image can be referred

[Panarba]

It's not working, Can I get a more detailed solution?

[Anonymous]

Hi @Panarba,

According to the error message and code, it seems like there is an issue with the gateway connection to the data source.

Troubleshoot the on-premises data gateway | Microsoft Learn

BTW, the error message also mentions the issue could be related to queries timeout. You can look at the dataset refresh timeout and query timeout to confirm these settings.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi, did you manage to solve this? Im having the same issue