Forum Discussion

Panarba's avatar
Panarba
Frequent Visitor
3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

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

  • Panarba's avatar
    Panarba
    Frequent Visitor

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