Forum Discussion
Error during data processing in the dataset from PostgreSQL
Hello everyone,
I am using an on-premises data gateway to connect to PostgreSQL for updating a report. I made the connection, but when updating, the following error message appears. Could you help me resolve it?
Data source error: [ValidateMarkupTags]{"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":"[ccon]Please install Npgsql version 4.0.16.0</ip> or earlier.[/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10305"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"PostgreSQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"[ccon][ccon]<ip>XXXXXXXXX</ip>[/ccon]<ip><ip>XXXXXXXXX</ip></ip>:6432;sanesantos[/ccon]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.MissingClientLibrary"}}],"exceptionCulprit":1}}} Table: fNcsEqI_irregular_items.
Cluster URI: WABI-NORTH-EUROPE-J-PRIMARY-redirect.analysis.windows.net
Activity ID: ca918a6c-bf6a-4be1-aefe-a02549dccc54
Request ID: b253fbf8-3b55-9dd3-6649-0f6cb27e8265
Time: 2024-11-26 17:36:11Z
Thanks!
2 Replies
- GilbertQSuper User
Hi davidsonunes
As per the error message, please, could you install the following on your gateway server? Please install Npgsql version 4.0.16.0
- AnonymousNot applicable
Thanks for the reply from GilbertQ, please allow me to provide another insight.
Hi davidsonunes ,
You can try connecting to PostgreSQL via ODBC and then performing refreshes in the service.PostgreSQL data refresh using Data Gateway in Power BI report | by Ramu Vudugula | Medium
The following are similar issues that may be helpful.
Solved: An exception occurred: Please install Npgsql versi... - Page 2 - Microsoft Fabric Community
Solved: Gateway error connecting to PostgreSQL - Page 2 - Microsoft Fabric Community
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.