Power BI Service Refresh Failing Intermittently for PostgreSQL Source

Error

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": "ODBC: ERROR [08001] SCRAM authentication requires libpq version 10 or above\n" }
                },
                {
                    "code": "DM_ErrorDetailNameCode_UnderlyingHResult",
                    "detail": { "type": 1, "value": "-2147467259" }
                },
                {
                    "code": "Microsoft.Data.Mashup.ErrorCode",
                    "detail": { "type": 1, "value": "10478" }
                },
                {
                    "code": "Microsoft.Data.Mashup.ValueError.DataSourceKind",
                    "detail": { "type": 1, "value": "Odbc" }
                },
                {
                    "code": "Microsoft.Data.Mashup.ValueError.DataSourcePath",
                    "detail": { "type": 1, "value": "dsn=DB_01" }
                },
                {
                    "code": "Microsoft.Data.Mashup.ValueError.NativeError",
                    "detail": { "type": 1, "value": "101" }
                },
                {
                    "code": "Microsoft.Data.Mashup.ValueError.OdbcErrors",
                    "detail": {
                        "type": 1,
                        "value": "#table((\"SQLState\", \"NativeError\", \"Message\"), {})"
                    }
                },
                {
                    "code": "Microsoft.Data.Mashup.ValueError.Reason",
                    "detail": { "type": 1, "value": "DataSource.Error" }
                },
                {
                    "code": "Microsoft.Data.Mashup.ValueError.SQLState",
                    "detail": { "type": 1, "value": "08001" }
                }
            ],
            "exceptionCulprit": 1
        }
    }
}

Here is the error. This issue has been occurring since around Nov ’25. My reports have been live since May ’25 with only occasional failures earlier. Over time the refresh failures have increased and are now frequent and random across eight scheduled refreshes.

Relevant Details:

• I have 3 reports using different combinations of the DB_01and DB_02 databases.
• Only the reports that include DB_01 fail; the DB_02 only report always succeeds.
• The refresh always succeeds in Power BI Desktop.
• The Power BI admin team manages the gateway and DSN configuration on their side.
• They suggested updating the System DSN to Unicode, re-entering credentials, and they also shared the driver details from all gateway nodes.
• All PostgreSQL ODBC drivers are updated on my system and on all three gateway cluster nodes.
• The System DSN for DB_01 was updated from PostgreSQL ANSI (x64) to Unicode (x64) as suggested.
• The DBA switched DB_01 authentication from SCRAM to MD5 on their suggestion.
• Despite all these changes, the same error still appears during gateway refresh.
• There are 8 scheduled refreshes every 3 hours, and failures occur randomly across these runs.

So the PBI admin team is leaning toward this being a SCRAM issue, but I want to confirm whether it is actually SCRAM or if there is another underlying error that we are overlooking. Any guidance or help in identifying the real cause would be appreciated.