postgresql odbc authentication error

Question

Hi everyone:&nbsp;I've been having trouble connecting to PostgreSQL by ODBC. The aplication responds with an error: "password authentication failed for user 'postgres'".&nbsp;I try this credentials with other clients and work fine.I have installed npgsql-4.0.10 and configure system DSC in windows.The server don't use SSL Encryption.&nbsp;Thank you!&nbsp;

mathoucds · Answer

Hi&nbsp;Anonymous&nbsp;, do you have '%' in your password? If it's the case, you can try to replace '%' by '%25'https://community.powerbi.com/t5/Issues/PostgreSQL-ODBC-to-PowerBI-Password/idi-p/874849

dax · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;
You could try to delete the credential in Datasource Setting, then re-enter it to see whether it work or not. You could try to refer to&nbsp;Connecting Power BI To PostgreSQL&nbsp; for details.
Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi:&nbsp;I try to restart DSN and power bi connection (detele all permitions and restar de connection), but still not working.&nbsp;&nbsp;Thank you!&nbsp;

amicci · Answer

spent the past 4 ours trying to make this damnmed thing work and this is the solution.the werid thing is that in the ODBC local instance it accepts the % normally however when authenticating trough PBI it does not.

Forum Discussion

postgresql odbc authentication error

4 Replies

Related content

KeyPair authentication Snowflake error

Authentication error with Fabric App

API authentication error on scheduled refresh

Google Analytics GA4 Authentication Error

event trigger authentication & error fetch