Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone:
I've been having trouble connecting to PostgreSQL by ODBC. The aplication responds with an error: "password authentication failed for user 'postgres'". 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.
Thank you!
Hi @Anonymous ,
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 Connecting Power BI To PostgreSQL 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.
Hi:
I try to restart DSN and power bi connection (detele all permitions and restar de connection), but still not working.
Thank you!
Hi @Anonymous , 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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |