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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Panarba
Frequent Visitor

Issue with Automatic Refresh

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

4 REPLIES 4
Panarba
Frequent Visitor

Below image can be referred

Panarba_1-1693999142461.png

 

Panarba
Frequent Visitor

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

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.