Forum Discussion
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
- AnonymousNot 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
- AnonymousNot applicable
Hi, did you manage to solve this? Im having the same issue
- PanarbaFrequent Visitor
It's not working, Can I get a more detailed solution?
- PanarbaFrequent Visitor
Below image can be referred