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.
Hope I moved your answer to the appropriate thread. 🙂
Hey, thanks for the suggestion. I have asked the admin team to follow through your instructions. Will update this thread once they revert.
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
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 questionsHello 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.
