Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
Below image can be referred
It's not working, Can I get a more detailed solution?
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
Hi, did you manage to solve this? Im having the same issue
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
76 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |