Forum Discussion
Power BI Service Refresh Failing Intermittently for PostgreSQL Source
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.
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.
Hey, thanks for the suggestion. I have asked the admin team to follow through your instructions. Will update this thread once they revert.