Power BI Service Refresh Failing Intermittently for PostgreSQL Source

[abhijit_mohanty]

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.

[MohdZaid_]

Hey @damit230183  , 

You’re getting this specific error from the gateway layer:

ODBC: ERROR [08001] SCRAM authentication requires libpq version 10 or above
DataSourceKind = Odbc
DSN = DB_01

This is not a generic network error. It is explicitly an authentication library version mismatch coming from the PostgreSQL client library (libpq) used by the ODBC driver on the gateway machine.

Since this only happens in Power BI Service and never in Desktop, the problem is almost certainly on the On-Premises Data Gateway cluster, not your report or the database itself.

The error means:

The ODBC driver on at least one gateway node is loading a libpq version older than v10, which does not support SCRAM-SHA-256 authentication.

https://www.postgresql.org/docs/current/auth-password.html

https://odbc.postgresql.org/docs/config.html 

[v-sshirivolu]

Hi @abhijit_mohanty ,

I would also take a moment to thank @MohdZaid_, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[v-sshirivolu]

Hi @abhijit_mohanty ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[abhijit_mohanty]

Hello @v-sshirivolu & @MohdZaid_ ,
So, the final workaround that was suggested to me - update the source to PostgreSQL connector from the ODBC.
As of now 8 refreshes have been processed and 0 fails.

[abhijit_mohanty]

Hey, thanks for the suggestion. I have asked the admin team to follow through your instructions. Will update this thread once they revert.

[tharunkumarRTK]

@MohdZaid_ 

Hope I moved your answer to the appropriate thread. 🙂 

[Jai-Rathinavel]

@abhijit_mohanty Maybe the issue is due to Postgres and not in Power BI. Please check the below post

https://stackoverflow.com/questions/62807717/how-can-i-solve-postgresql-scram-authentication-problem

[abhijit_mohanty]

Thank you for the reply. My admin team is looking into this. Will keep you posted if this worked.